Exporting to Microsoft Excel PivotTable reports creates two sheets for each type of data you choose to export. One sheet ...

Exporting to Microsoft Excel PivotTable reports creates two sheets for each type of data you choose to export.  One sheet contains the data used for the PivotTable report and the other contains a default PivotTable report.  The last field in each map is used as the default Data field for the PivotTable report.  All other fields are used as Row fields in the PivotTable report.