Pivot Grid Chart Limitations

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.