XML - pivotTable part
The pivotTable part is organized into 11 sections.
Top-level attributes
Location information
Collection of Fields
Fields on the row axis
Items on the row axis (specific values)
Fields on the column axis
Items on the column axis (specific values)
Fields in the report filter area
Fields in the values area
Style information
This is what the shell of that structure looks like:
<pivotTableDefinition> <location/> <pivotFields/> <rowFields/> <rowItems/> <colFields/> <colItems/> <pageFields/> <dataFields/> </dataFields> <conditionalFormats/> <pivotTableStyleInfo/> </pivotTableDefinition>
Each collection will now be addressed section by section.