<filter> (PivotTable Advanced Filter)

Represents a PivotTable advanced filter.

example:
<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

<filters>3.10.1.34)

Child Elements

Subclause

<autoFilter> (AutoFilter Settings)

§3.3.1.1

<extLst> (Future Feature Data Storage Area)

§3.2.10

Attributes

Description

<description> (Pivot Filter 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).

<evalOrder> (Evaluation Order)

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.

<fld> (Field Index)

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.

<id> (Pivot Filter Id)

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.

<iMeasureFld> (Measure Field Index)

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.

<iMeasureHier> (Measure Index)

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.

<mpFld> (Member Property Field Id)

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.

<name> (Pivot Filter Name)

Specifies the name of the pivot filter.

The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).

<stringValue1> (Label Pivot)

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).

<stringValue2> (Label Pivot Filter String Value 2)

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).

<type> (Pivot Filter Type)

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>