Pivot Grid Excel Export

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.

export pivot table to Excel

spreadsheet view

pivot table fields

Support Contact Information

If you have any support needs or questions regarding the software, please contact support@anterratech.com for assistance.


    • Related Articles

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

    • Anterra Version v28 Release Notes

      AnterraBI™ v28 has been released to Production! Below are the enhancements available today. Summary S-curve Billing and Cost Graphs – measure earned value/billings ahead and behind S-curves Anterra Ad Hoc – integration of Amazon QuickSight S -curve ...

    • Setting the Default Date for a Pivot Grid

      Pivot Grids now support the ability to define the default date to show when visiting the grid, you can select from the following options when saving a grid. To get to the save grid area shown you must alter a grid so that the save icon in the top ...

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

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