Share via

2.3.27 CT_PivotTable

  • Article

Referenced by: CT_PivotTables

A PivotTable.

Child Elements:

Ranges: MUST contain the unordered list of all the ranges where the range of the PivotTable intersects with the returned range.

DataFields: MUST contain the list of all the PivotTable data fields of the PivotTable represented by the parent element.

RowHeaderRange: Specifies the range of cells that comprise the row headers.

ColumnHeaderRange: Specifies the range of cells that comprise the column headers in the PivotTable.

RowAreaCaptions: Specifies the cell values from the inner-most row header for the displayed range.

Attributes:

ExternalSourceIndex: An identifier that the protocol server uses to identify a connected data. MUST be 0 if LocalSource attribute is true.

AdvancedFilters: MUST be ignored on receipt by the protocol client.

LocalSource: Specifies whether the PivotTable is a native PivotTable. MUST be true if the PivotTable is a native PivotTable.

Name: The identifier of a PivotTable.

DataConnectionName: An identifier that the protocol server uses to identify the data connection.

ShowDrillIndicators: Specifies whether the PivotTable allows displaying drill indicators. MUST be false if the PivotTable does not allow displaying drill indicators.

RequiresConnection: Specifies whether the PivotTable requires an external data connection to update the contents of the PivotTable. MUST be true if the PivotTable requires an external data connection to update the contents of the PivotTable.

FieldListVersion: A unique identifier for the state of the PivotTable fields on the protocol server.

FieldWellVersion: A unique identifier for the state of the PivotTable on the protocol server.

IsActionable: Specifies whether the PivotTable supports interactivity. MUST be true if the PivotTable supports interactivity.

IsOlap: Specifies whether the PivotTable represents OLAP data. MUST be true if the PivotTable represents OLAP data.

SupportsBIExplore: Specifies whether the PivotTable supports data exploration. MUST be true if the PivotTable supports data exploration.

HideGridLines: Specifies whether the gridlines inside a pivot table are hidden. MUST be true if the gridlines inside a pivot table are hidden. Otherwise MUST be false.

RowTotalIndexes: Specifies which rows of a pivot table range contain values that are totals. Each bit represents a row in the range being rendered (bit 1 = row 1). If the bit has a value of 1, that row contains totals.

ColumnTotalIndexes: Specifies which columns of a pivot table range contain values that are totals. Each bit represents a column in the range being rendered (bit 1 = column 1). If the bit has a value of 1, that column contains totals.

RowMemberPropIndexes: Specifies which rows of a pivot table range contain member properties. Each bit represents a row in the range being rendered (bit 1 = row 1). If the bit has a value of 1, that row contains member properties.

ColumnMemberPropIndexes: Specifies which columns of a pivot table contain member properties. Each bit represents a column in the range being rendered (bit 1 = column 1). If the bit has a value of 1, that column contains member properties.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

 <xs:complexType name="CT_PivotTable">
   <xs:sequence>
     <xs:element name="Ranges" minOccurs="1" maxOccurs="1" type="CT_Ranges"/>
     <xs:element name="DataFields" minOccurs="0" maxOccurs="1" type="CT_DataFields"/>
     <xs:element name="RowHeaderRange" minOccurs="0" maxOccurs="1" type="CT_range"/>
     <xs:element name="ColumnHeaderRange" minOccurs="0" maxOccurs="1" type="CT_range"/>
     <xs:element name="RowAreaCaptions" minOccurs="0" maxOccurs="1" type="CT_CellValues"/>
   </xs:sequence>
   <xs:attribute name="ExternalSourceIndex" type="ST_nonNegativeInteger" default="0" use="optional"/>
   <xs:attribute name="AdvancedFilters" type="xs:boolean" default="false" use="optional"/>
   <xs:attribute name="LocalSource" type="xs:boolean" use="optional" default="false"/>
   <xs:attribute name="Name" type="ST_nonEmptyString"/>
   <xs:attribute name="DataConnectionName" type="ST_nonEmptyString"/>
   <xs:attribute name="ShowDrillIndicators" type="xs:boolean" default="true" use="optional"/>
   <xs:attribute name="RequiresConnection" type="xs:boolean" use="optional" default="false"/>
   <xs:attribute name="FieldListVersion" type="xs:int"/>
   <xs:attribute name="FieldWellVersion" type="xs:int"/>
   <xs:attribute name="IsActionable" type="xs:boolean" default="false" use="optional"/>
   <xs:attribute name="IsOlap" type="xs:boolean" default="false" use="optional"/>
   <xs:attribute name="SupportsBIExplore" type="xs:boolean" use="optional" default="false"/>
   <xs:attribute name="HideGridLines" type="xs:boolean" use="optional" default="false"/>
   <xs:attribute name="RowTotalIndexes" type="xs:int" default="0" use="optional"/>
   <xs:attribute name="ColumnTotalIndexes" type="xs:int" default="0" use="optional"/>
   <xs:attribute name="RowMemberPropIndexes" type="xs:int" default="0" use="optional"/>
   <xs:attribute name="ColumnMemberPropIndexes" type="xs:int" default="0" use="optional"/>
 </xs:complexType>

See section 5.1 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).