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! 

















A look at the Division Level:



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



Clicking on a Project Manager drills to the detailed grid.



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


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:


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

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