Limitations of Charts and Grids

Pivot Grid chart has these limitations:

• Users can only assign Value fields to the Y axis because they are numerical.

• If users select Chart Only as a display option, then only one level of detail can appear in the chart, and users can have one field on the X axis and one field as a data series to group the data.

• If users drill down on the chart, they can select an overlay field to display two fields on the Y axis. If an overlay field is selected, then two charts are plotted, and one is superimposed over the other.

  Note: From PeopleTools 8.55, you can select multiple Y axes to be plotted in a Chart Only view.

  From PeopleTools 8.53, the Chart Only view does not limit the number of filters.

• If users select multiple Data Source Columns as Y-axes, then the Overlay feature is restricted as follows:

  • In the Fluid Pivot Grid Viewer, the Overlay will not be available under Chart Options. Chart Options is accessed from the Menu Options button on the pivot grid chart.

  • In Step 4: Specifying Data Model Options of the pivot grid wizard, selecting Overlay as a Chart Axis for a Data Source Column will be considered invalid.

• If users select Pivot Grid and Chart as a display option, then the chart can use one Y axis for plotting one of the Value members, and all the other axes are automatically determined based on the current grid layout.

  Note: In PeopleSoft Pivot Grid, overlay fields for a Pivot Grid and Chart display option are not supported.

Pivot Grid grids has these limitations:

• It does not have a vertical scroll bar for viewing data, but it displays all possible rows based on the current layout.

• Pagination is not available.

• Pivot Grid grid supports up to 75 axes and values; the character limit for each is 30.