Pivot Grid Collapsed Grouping View

Pivot Grid Collapsed Grouping View

Anterra has enhanced the Pivot Grid collapse functionality significantly. Below is a view of Margin Gain Erosion grouped by Division and Project Manager.
Clicking on the check box to the left of “Collapse Pivot Table” creates a drill-through report! 

Collapse Pivot Table
















A look at the Division Level:

Division Level

Clicking on the General Construction parameter displays the second pivot – Project Manager.

second pivot

Clicking on a Project Manager drills to the detailed grid.

detailed grid

Note that there is a breadcrumb on top of the grid to navigate up to the top:
breadcrumb on top of the grid

NOTES
1.      You can save collapsed views!  Simply click on the save icon beside the view name:



2.      If you would like to see the hierarchy view of the pivot grid click on the ellipsis in the far left column:

hierarchy view