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 and ...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 first ...