<filter>
(PivotTable Advanced Filter)
Represents a PivotTable advanced filter.
<sh:filter fld="3" type="count" id="1" iMeasureHier="187"> <sh:autoFilter ref="A1"> <sh:filterColumn colId="0"> <sh:top10 val="5"/> </sh:filterColumn> </sh:autoFilter> </sh:filter>
Parent Elements |
---|
|
Child Elements |
Subclause |
---|---|
|
|
|
Attributes |
Description |
---|---|
|
Specifies the description of the pivot filter. The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
|
Specifies the evaluation order of the pivot filter. This attribute is zero-based. The possible values for this attribute are defined by the XML Schema int datatype. |
|
Specifies the index of the field to which this pivot filter belongs. The possible values for this attribute are defined by the XML Schema unsignedInt datatype. |
|
Specifies the unique identifier of the pivot filter as assigned by the PivotTable. The possible values for this attribute are defined by the XML Schema unsignedInt datatype. |
|
Specifies the index of the measure field. This attribute is used only by filters in Relational pivots and specifies on which measure a value filter should apply. The possible values for this attribute are defined by the XML Schema unsignedInt datatype. |
|
Specifies the index of the measure cube field. This attribute is used only by filters in OLAP pivots and specifies on which measure a value filter should apply. The possible values for this attribute are defined by the XML Schema unsignedInt datatype. |
|
Specifies the index of the field representing the member property field on which this pivot filter is defined. This attribute is used only by label pivot filters. The possible values for this attribute are defined by the XML Schema unsignedInt datatype. |
|
Specifies the name of the pivot filter. The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
|
Specifies the string value "1" used by label pivot filters. The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
|
Specifies the string value "2" used by label pivot filters. The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
|
Specifies the type of the pivot filter. The possible values for this attribute are defined by the ST_PivotFilterType simple type (§3.18.61). |
The following XML Schema fragment defines the contents of this element:
<complexType name="CT_PivotFilter">
<sequence>
<element name="autoFilter" minOccurs="1" maxOccurs="1" type="CT_AutoFilter"/>
<element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
</sequence>
<attribute name="fld" use="required" type="xsd:unsignedInt"/>
<attribute name="mpFld" type="xsd:unsignedInt" use="optional"/>
<attribute name="type" use="required" type="ST_PivotFilterType"/>
<attribute name="evalOrder" use="optional" type="xsd:int" default="0"/>
<attribute name="id" use="required" type="xsd:unsignedInt"/>
<attribute name="iMeasureHier" use="optional" type="xsd:unsignedInt"/>
<attribute name="iMeasureFld" use="optional" type="xsd:unsignedInt"/>
<attribute name="name" type="ST_Xstring"/>
<attribute name="description" type="ST_Xstring"/>
<attribute name="stringValue1" type="ST_Xstring"/>
<attribute name="stringValue2" type="ST_Xstring"/>
</complexType>