ssml:filter

PivotTable Advanced Filter

Element information

Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main

Schema document: sml-pivotTable.xsd

Other elements with the same name: ssml:filter

Type: ssml:CT_PivotFilter

Properties: Local, Qualified

Content

Sequence [1..1]
1. ssml:autoFilter [1..1] Auto Filter
2. ssml:extLst [0..1] Future Feature Storage Area

Attributes

Name	Occ	Type	Description	Notes
fld	[1..1]	xsd:unsignedInt	Field Index
mpFld	[0..1]	xsd:unsignedInt	Member Property Field Id
type	[1..1]	ssml:ST_PivotFilterType	Pivot Filter Type
evalOrder	[0..1]	xsd:int	Evaluation Order	Default value is "0".
id	[1..1]	xsd:unsignedInt	Pivot Filter Id
iMeasureHier	[0..1]	xsd:unsignedInt	Measure Index
iMeasureFld	[0..1]	xsd:unsignedInt	Measure Field Index
name	[0..1]	ssml:ST_Xstring	Pivot Filter Name
description	[0..1]	ssml:ST_Xstring	Pivot Filter Description
stringValue1	[0..1]	ssml:ST_Xstring	Label Pivot
stringValue2	[0..1]	ssml:ST_Xstring	Label Pivot Filter String Value 2

Used in

Type ssml:CT_PivotFilters (Element ssml:filters)

Sample instance

<ssml:filter fld="1" type="unknown" id="1">
   <ssml:autoFilter>
      <ssml:filterColumn colId="1">
         <ssml:filters>...
         </ssml:filters>
      </ssml:filterColumn>
      <ssml:sortState ref="string">
         <ssml:sortCondition ref="string" iconSet="3Arrows"/>
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:sortState>
      <ssml:extLst>
         <ssml:ext>
            <!--any element-->
         </ssml:ext>
      </ssml:extLst>
   </ssml:autoFilter>
   <ssml:extLst>
      <ssml:ext>
         <!--any element-->
      </ssml:ext>
   </ssml:extLst>
</ssml:filter>