.
...
| Note |
|---|
Take special note of the data options, particularly Refresh data when opening the file and Number of items to retain per field, as they are important for ensuring properly rendered PivotTables in ExcelWriter output. More details are available in our ExcelTemplate Templates and PivotTables and ExcelApplication Creating a Basic PivotTable tutorials. |
PivotTable Field
PivotTable Field Settings
A PivotTable is made up of different PivotTable fields, which can perform different actions on data. PivotTable fields are created from source fields. In Excel this is done by dragging a source field into one of the pivot field areas.
An example of PivotTable fields created from source fields.
Row and Column Label
Row labels and Column Labels group the same values together to nest data and display subtotals for different groups.
Report Filters (Page Fields)
Report Filters, or page fields,