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

    • Related Articles

    • Anterra Pivot Grids

      Contents Overview of Anterra Pivot Grids Steps to create and save a Anterra PivotGrid 1. Select your Parameters 2. Apply Filters and Sorting 3. Adding and Removing Columns on a Anterra PivotGrid 4. Moving columns 5. Grouping / Pivoting Columns 6. ...

    • Persisted Grids

      Persisted Grids   Steps to create and save a Persisted Grid: Select your Parameters Apply Filters and Sorting Adding and Removing Columns on a Persisted Grid Moving columns Grouping/Pivoting Columns Sorting Columns Exporting a grid to Excel Saving a ...

    • Setting Report Favorites

      Set report Favorites from the Favorites icon on the far right of the top bar while a report is showing by clicking on Add to Favorites (indicated by yellow star): Or set Favorites from the report menu by clicking on the Favorites icon next to the ...

    • Pivot Grid: AP Vendor Payment Grid

      Version 25 Release NEW PIVOT GRID Purpose: Review invoices and payments by vendor over a range of dates. This grid replaces an SSRS Report with pivot grid technology. MENU ITEM: Finance > AP Status > AP Vendor Payment Inquiry (PG) REPORT SECURITY: ...

    • Pivot Tables in the Excel Export

      When exporting a grid to Excel, you will see three tabs along the bottom: the Data, a PivotTable, and PivotChart. Use the PivotTable sheet to easily build a pivot table from the data by choosing fields from the PivotTable Fields list on the right and ...