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.






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