2.2.4.26 PivotFilterItem

  • Article

Namespace: http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/

A PivotTable member that is part of a PivotTable manual filter hierarchy.

 <xs:complexType name="PivotFilterItem">
   <xs:complexContent mixed="false">
     <xs:extension base="tns:PivotFilterItemList">
       <xs:sequence>
         <xs:element minOccurs="1" maxOccurs="1" name="CalculatedMember" type="xs:boolean"/>
         <xs:element minOccurs="1" maxOccurs="1" name="LeafItem" type="xs:boolean"/>
         <xs:element minOccurs="1" maxOccurs="1" name="Selected" type="xs:boolean"/>
         <xs:element minOccurs="1" maxOccurs="1" name="Id" type="xs:int"/>
         <xs:element minOccurs="0" maxOccurs="1" name="DisplayString" type="xs:string"/>
       </xs:sequence>
     </xs:extension>
   </xs:complexContent>
 </xs:complexType>

CalculatedMember: Specifies whether the PivotTable member is a calculated PivotTable member . MUST be set to "true" if the PivotTable member is a calculated PivotTable member, and MUST be set to "false" otherwise.

LeafItem: Specifies whether the PivotTable member has no child objects in the PivotTable manual filter hierarchy. MUST be set to "true" if the PivotTable member has no child objects in the PivotTable manual filter hierarchy, and MUST be set to "false" otherwise.

Selected: Specifies whether the PivotTable member or all its descendants in the hierarchy are selected. If LeafItem is "true", MUST be set to "true" if the PivotTable member is selected, and MUST be set to "false" otherwise. If LeafItem is "false", MUST be set to "true" if all the descendants of the PivotTable member in the hierarchy are selected, and MUST be set to "false" otherwise.

Id: A unique identifier of the PivotTable member. MUST be greater than or equal to zero. MUST be unique across all the PivotTable members in the PivotTable manual filter hierarchy.

DisplayString: The caption of the PivotTable member. MUST be present. MUST NOT be empty.