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. ...

    • 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: ...

    • 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 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 ...

    • Pivot Grid Group Counts Added

      Version 25 Release All pivot grids now show you the number of items for each pivot table group. In this example, the Margin Gain Erosion grid is grouping jobs by Division, then Project Manager. The General Construction division has 11 jobs, the first ...