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.