Share via

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" xmlns:xs="http://www.w3.org/2001/XMLSchema">
   <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 0. 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.