filters (Filters)

Represents the collection of filters that apply to this PivotTable.

[Example:

<sh:filters count="1">
<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>
</sh:filters>

end example]

Parent Elements

pivotTableDefinition (§3.10.1.73)

 

Child Elements	Subclause
filter (PivotTable Advanced Filter)	§3.10.1.33

 

Attributes	Description
count (Pivot Filter Count)	Specifies the number of pivot filters in the collection.   The possible values for this attribute are defined by the XML Schema unsignedInt datatype.

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_PivotFilters">

   <sequence>

   <element name="filter" minOccurs="0" maxOccurs="unbounded" type="CT_PivotFilter"/>

   </sequence>

   <attribute name="count" type="xsd:unsignedInt" default="0"/>

</complexType>