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 Version v25.2 Release Notes

  Anterra Version 25.2 Release Notes Updates to Anterra Pivot Grids These are general updates that apply to most of the grids through every module (Finance, Construction, and Service Management) Setting the Default Date for a Pivot Grid - KB Pivot ...

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

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