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