Share via

2.4.26 pivotHierarchy

  • Article

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

A pivotHierarchy element is a CT_PivotHierarchy type element, as specified in section 2.6.47, that specifies multiple data items based on the same OLAP measure that exists in a PivotTable, as specified in [ISO/IEC29500-1:2016] section 18.10, view. See section 2.2.4.5 for how this element integrates with the Office Open XML file formats specified in [ISO/IEC29500-1:2016].

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this element.

 <xsd:element name="pivotHierarchy" type="CT_PivotHierarchy"/>

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).