3.1.4.31.2.1 TogglePivotDrill

The TogglePivotDrill element is specified as follows.

 <s:element name="TogglePivotDrill">
   <s:complexType>
     <s:sequence>
       <s:element name="parameter" type="tns:CommandParameter" minOccurs="0"/>
       <s:element name="pivotFilterOptions" type="tns:PivotFilterOptions" minOccurs="0"/>
     </s:sequence>
   </s:complexType>
 </s:element>

parameter: A CommandParameter, as specified in section 2.2.4.11. MUST be present.

pivotFilterOptions: The PivotTable member to be expanded or collapsed. MUST be present. The following MUST extend or override the standard behavior specified in section 2.2.4.20: FieldId: MUST be present and empty.  Column: The column (2) of the PivotTable member. MUST be the zero-based column (2) number of a worksheet cell of the PivotTable that has the Drillable attribute of the Cell element (Section 2.2.4.24.38) set to true. Row: The row (2) of the PivotTable member. MUST be the zero-based row (2) number of a worksheet cell of the PivotTable that has the Drillable attribute of the Cell element set to true.