<consolidation>
(Consolidation Source)
Represents the description of the PivotCache source using multiple consolidation ranges. This element is used when the source of the PivotTable is a collection of ranges in the workbook. The ranges are specified in the <rangeSets>
collection. The logic for how the application consolidates the data in the ranges is application-specific. For example, the application may consolidate data based on its position in the worksheet that the end-user specifies.
Parent Elements |
---|
|
Attributes |
Description |
---|---|
|
Specifies a boolean value that indicates whether the application will automatically create one additional page field to describe/qualify the source ranges. A value of on, 1, or true indicates the application will create an additional page field. A value of off, 0, or false indicates will not create an additional page field. The possible values for this attribute are defined by the XML Schema boolean datatype. |
The following XML Schema fragment defines the contents of this element:
<complexType name="CT_Consolidation">
<sequence>
<element name="pages" type="CT_Pages" minOccurs="0" maxOccurs="1"/>
<element name="rangeSets" type="CT_RangeSets" minOccurs="1" maxOccurs="1"/>
</sequence>
<attribute name="autoPage" type="xsd:boolean" default="true" use="optional"/>
</complexType>