Describing Features of the Classic Pivot Grid Viewer

Term Definition

Option Menu icon

Use the Option Menu icon to select the actions for viewing the Pivot Grid model.

See, Using the Options Menu.

Help icon

Click the Help icon to display the Help - Pivot Grid dialog box, where you can view the help information for all actions in this page.

You can define the Help icon and its embedded help information for each Pivot Grid model using the Show Help option in the Pivot Grid Wizard - Specify Data Model Options page, Viewer Options section.

See Creating a New Pivot Grid Pagelet Using the Pagelet Wizard.

Expand All and Collapse All

The Expand All and Collapse All links appear when the Pivot Grid model contains dimensions with totals on the lowest level of the grid row or column. These links are not available for the Pivot Grid models that have no totals defined for dimensions on the grid row and grid column.

Click the Expand All link to expand all the positions on the grid row and column, and the Collapse All link appears.

Click the Collapse All link to collapse all the positions on the grid row and column, and the Expand All link appears.

Hide Filter icon

Click the Hide Filter icon to collapse the section that displays the Pivot Grid filter options for the Pivot Grid models that have the grid-only mode.

Show Filter icon

Click the Show Filter icon to expand the section that displays the Pivot Grid filter options for the Pivot Grid models that have the grid-only mode.

Filter

Displays the Pivot Grid filter options for the Pivot Grid models that have the chart-only mode.

You can click to collapse or expand the section. The default setting is the expanded state.

Download to Excel icon

Click the Download icon to download the slice of data seen in the pivot grid to Microsoft Excel.

Show All Columns icon

Click the Show All Columns icon to display all the grid columns.

Show scrolling bar icon

Click the Show Scrolling icon to scroll columns.

Bar icon

Click the Bar icon to display data in a bar chart.

Line icon

Click the Line icon to display data in a line chart.

Pie icon

Click the Pie icon to display data in a pie chart.

Horizontal Bar Chart icon

Click the Horizontal Bar Chart icon to display data in a horizontal bar chart.

<Chart>

If the Related Actions are not configured for the aggregate view, clicking the data point on the chart enables you to directly access the detailed view to view the data that is being plotted.

If the Related Actions are configured on the aggregate view, clicking the data point on the chart displays a context menu with a list of available actions: Detailed View, Drilldown To, and Actions.

Note: Beginning from PeopleTools 8.54, you select a chart data point in a Pivot Grid and Chart view to see the detail view for the data point or perform aggregate related actions (if configured).

Return

Click the Return button to close the Pivot Grid view and return to the Pivot Grid Viewer page.