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 drag fields between the areas below the list:

Use the PivotChart sheet to build a PivotChart by choosing fields from the list on the right:

 

See also

Changing Filters
Hiding Parameters and Document Map
Drilling into Numbers and Graphs
Using Sort on Grids
Using Grouping on Grids
Using Filters on Grids
Drop Downs on Grids
Breadcrumbs/Hover over Graphs
Setting Report Favorites
Search for Reports
Export and Print

• Related Articles

• Pivot Grid Excel Export

  Pivot Grid Excel Export When you export the pivot table to Excel, it exports with all visible columns.  The pivot column order is dependent on the order of columns on the grid, not the order of pivoted columns.  See the example below. Support Contact ...

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

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

• General FAQ

  1.  Can security be set up to limit access to Consolidation Groups?       Yes, please contact Anterra Tech to limit users access to just certain Consolidation Groups. 2.  How can users get support?        Please see Support Contact Information. 3. ...