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

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>