Performing Actions on the Pivot Grid Viewer
Click the + button to drill down a dimension on the pivot grid.
Drill down the aggregate values like SUM, AVG, COUNT, and so on. Click the aggregate value displayed on the grid to display the data that comprise the aggregate value.
While performing drill down on the aggregate values, note that:
You may not be able to drill down an aggregate value if the authentication domain is incorrect. Set it up from the PeopleSoft Pure Internet Architecture or in the Web Profile page. See “Configuring General Portal Properties” in Configuring Web Profiles.
When you move the mouse over the value numbers, they appear as underlined links. Click the links to open the Detailed Data view for the aggregate value.
If related actions are configured for the aggregate view, clicking the value number links populates a context menu with two options: Detailed View and Actions.
By clicking the data point on the chart, you can also drill down on aggregate values in the chart to view the detailed data that represents the chart data point; for example, a bar, a pie section, a line chart data point, and so on. If related actions are configured for the aggregate view, clicking the data point on the charts populates a context menu with three options: Detailed View, Drilldown To, and Actions.
When there is any change in the pivot grid, the corresponding chart also shows the change.
Chart also shows similar changes when there is any modification made to the grid.
You can move a row to a column and other way round too. Chart will also reflect changes made to the grid.
You can use the filter above the grid on the pivot grid viewer to select specific items. The grid and chart changes accordingly. You can select single or multiple values from one or more filter dropdown options. The filters also apply progressive filtering if they are dependent on each other.