L.2.9.3.4 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 is now addressed below section by section.

Subsections

• L.2.9.3.4.1 Attributes on pivotTableDefinition
• L.2.9.3.4.2 Location Information
• L.2.9.3.4.3 PivotTable Fields
• L.2.9.3.4.4 Row Axis Fields
• L.2.9.3.4.5 Row Items
• L.2.9.3.4.6 Column Axis Fields
• L.2.9.3.4.7 Column Items
• L.2.9.3.4.8 Report Filter Area Fields
• L.2.9.3.4.9 Values Area Fields
• L.2.9.3.4.10 PivotTable Style Information