Documentation for Microsoft Office 2003 Reference Schemas
Definition Type: ComplexType
Name: PivotFieldType
Namespace: urn:schemas-microsoft-com:office:excel
Containing Schema: excel.xsd
Abstract
Documentation:
Contains information about a PivotField.
Collapse XSD Schema Diagram:
Drilldown into TotalWidth in schema excel_xsd Drilldown into TotalCaptionAlignment in schema excel_xsd Drilldown into TotalAlignment in schema excel_xsd Drilldown into SubtotalFormat in schema excel_xsd Drilldown into PivotItem in schema excel_xsd Drilldown into SourceHierarchyLevel in schema excel_xsd Drilldown into MemberPropertyParent in schema excel_xsd Drilldown into SourceHierarchy in schema excel_xsd Drilldown into PLSubtotal in schema excel_xsd Drilldown into PLPosition in schema excel_xsd Drilldown into PLName in schema excel_xsd Drilldown into PLGroupType in schema excel_xsd Drilldown into PLDataOrientation in schema excel_xsd Drilldown into PLCaption in schema excel_xsd Drilldown into NewItemsHidden in schema excel_xsd Drilldown into GroupedWidth in schema excel_xsd Drilldown into ParseFormulaAsV10 in schema excel_xsd Drilldown into FormulaV10 in schema excel_xsd Drilldown into Formula in schema excel_xsd Drilldown into FilterCaption in schema excel_xsd Drilldown into Expanded in schema excel_xsd Drilldown into DetailWidth in schema excel_xsd Drilldown into DetailFormat in schema excel_xsd Drilldown into PLTPivotItem in schema excel_xsd Drilldown into SubtotalName in schema excel_xsd Drilldown into SQLType in schema excel_xsd Drilldown into ShowAllItems in schema excel_xsd Drilldown into ServerBased in schema excel_xsd Drilldown into DataType in schema excel_xsd Drilldown into Position in schema excel_xsd Drilldown into FilterMember in schema excel_xsd Drilldown into Caption in schema excel_xsd Drilldown into CurrentPage in schema excel_xsd Drilldown into IsMemberProperty in schema excel_xsd Drilldown into ServerSortOrder in schema excel_xsd Drilldown into DrilledLevel in schema excel_xsd Drilldown into HideDropDowns in schema excel_xsd Drilldown into MemberPropertiesOrder in schema excel_xsd Drilldown into MemberProperty in schema excel_xsd Drilldown into NoDragToPage in schema excel_xsd Drilldown into NoDragToHide in schema excel_xsd Drilldown into NoDragToData in schema excel_xsd Drilldown into NoDragToColumn in schema excel_xsd Drilldown into NoDragToRow in schema excel_xsd Drilldown into LayoutSubtotalLocation in schema excel_xsd Drilldown into LayoutForm in schema excel_xsd Drilldown into Subtotal in schema excel_xsd Drilldown into Function in schema excel_xsd Drilldown into Orientation in schema excel_xsd Drilldown into SourceName in schema excel_xsd Drilldown into ParentField in schema excel_xsd Drilldown into NumberFormat in schema excel_xsd Drilldown into LayoutPageBreak in schema excel_xsd Drilldown into GroupType in schema excel_xsd Drilldown into GroupEndAuto in schema excel_xsd Drilldown into GroupStartAuto in schema excel_xsd Drilldown into GroupEnd in schema excel_xsd Drilldown into GroupStart in schema excel_xsd Drilldown into GroupBy in schema excel_xsd Drilldown into CantGetUniqueItems in schema excel_xsd Drilldown into Calculation in schema excel_xsd Drilldown into BlankLineAfterItems in schema excel_xsd Drilldown into BaseItem in schema excel_xsd Drilldown into BaseField in schema excel_xsd Drilldown into AutoSortField in schema excel_xsd Drilldown into AutoSortOrder in schema excel_xsd Drilldown into AutoShowType in schema excel_xsd Drilldown into AutoShowRange in schema excel_xsd Drilldown into AutoShowField in schema excel_xsd Drilldown into AutoShowCount in schema excel_xsd Drilldown into MapChildItems in schema excel_xsd Drilldown into Name in schema excel_xsd Drilldown into DataField in schema excel_xsdXSD Diagram of PivotFieldType in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code: 
<xsd:complexType name="PivotFieldType">
    <xsd:annotation>
        <xsd:documentation>Contains information about a PivotField.</xsd:documentation>
    </xsd:annotation>
    <xsd:sequence>
        <xsd:element name="DataField" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Indicates that the PivotField element contains information for the data field of the report.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Name" type="xsd:string">
            <xsd:annotation>
                <xsd:documentation>Specifies the name of the PivotField. Also specifies the field in the data source that the PivotField represents. If the name of the PivotField and the name of the field in the data source are different, the SourceName element must also be used.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="MapChildItems" type="MapChildItemsType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the group to which mapped PivotItem belongs.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="AutoShowCount" type="xsd:int" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a number indicating what PivotItems to display based on the values of the PivotItems. Used in conjunction with AutoShowField, AutoShowRange and AutoShowType.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="AutoShowField" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the name of the PivotField in the data area of the PivotTable report from which to get the PivotItem value to be used when determining whether a PivotItem should be displayed or not. Used in conjunction with AutoShowCount, AutoShowRange and AutoShowType.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="AutoShowRange" type="AutoShowRangeType" default="Top" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains an enumeration indicating which range of values to use in determining whether a PivotItem should be displayed or not. Used in conjunction with AutoShowCount, AutoShowField and AutoShowType.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="AutoShowType" type="AutoShowTypeType" default="Manual" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains an enumeration indicating whether all PivotItems are displayed for a PivotField or whether the PivotItems displayed are based on the value falling within a user-specified range. Used in conjunction with AutoShowCount, AutoShowField and AutoShorRange.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="AutoSortOrder" type="AutoSortOrderType" default="Manual" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains an enumeration indicating how PivotItems, for this PivotField, are sorted in the PivotTable report. Used in conjunction with AutoSortField.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="AutoSortField" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the name of the PivotField being used to determine the sort order of the PivotItems in this PivotField.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="BaseField" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the name of the PivotField that this PivotField is derived from. Used for PivotFields in the data area and for PivotFields that have had their PivotItems grouped.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="BaseItem" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the name of the PivotItem that this PivotField is derived from. Used for PivotFields in the data area for certain calculation types.  Used in conjunction with BaseField and Calculation.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="BlankLineAfterItems" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies that a blank line is to be inserted after each change in value.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Calculation" type="CalculationPivotFieldType" default="Normal" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains an enumeration indicating the type of calculation being done for the PivotField that is in the data area of the PivotTable report.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="CantGetUniqueItems" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean indicating that a list of unique items from the data source for this PivotField was unavailable.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="GroupBy" type="xsd:int" default="1" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the size of the groups for PivotItems when PivotItems have been grouped.  Used in conjunction with GroupStart, GroupEnd, GroupStartAuto, GroupEndAuto, GroupType, ParentField and BaseField.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="GroupStart" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Indicates the first PivotItem of the first group when the PivotItems of a PivotField have been grouped. Used in conjunction with GroupBy, GroupEnd, GroupStartAuto, GroupEndAuto, GroupType, ParentField and BaseField.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="GroupEnd" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Indicates the last PivotItem of the last group when PivotItems have been grouped.  Used in conjunction with GroupBy, GroupStart, GroupStartAuto, GroupEndAuto, GroupType, ParentField and BaseField.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="GroupStartAuto" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Indicates that the first PivotItem of the first group should be picked automatically when the PivotItems of a PivotField have been grouped. Used in conjunction with GroupBy, GroupEnd, GroupStart, GroupEndAuto, GroupType, ParentField and BaseField.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="GroupEndAuto" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Indicates that the last PivotItem of the last group should be picked automatically when the PivotItems of a PivotField have been grouped. Used in conjunction with GroupBy, GroupEnd, GroupStart, GroupStartAuto, GroupType, ParentField and BaseField.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="GroupType" type="GroupTypeType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains an enumeration that indicates how the PivotItems of this PivotField are grouped.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="LayoutPageBreak" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>A Boolean indicating that a page break should be placed after each change in value for this PivotField.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NumberFormat" type="NumberFormatType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the display formatting to use when displaying the PivotItem or aggregate value.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="ParentField" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the name of the PivotField that is the parent (one level up) of this lower-level grouped PivotField. Used in conjunction with GroupBy, GroupEnd, GroupStart, GroupStartAuto, GroupType, GroupEnd and BaseField.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="SourceName" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the field in the data source that the PivotField represents. Not required if the name element of the PivotField matches the field name in the data source.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Orientation" type="OrientationType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether the field is to be used for row headers, column headers, page area, as data, or is hidden.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Function" type="FunctionType" default="Sum" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains an aggregation to be performed to calculate the value in the cell.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Subtotal" type="SubtotalType" default="Default" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Contains an enumeration indicating a type of subtotal to show for the PivotField. This element can appear multiple times specifying different subtotal types.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="LayoutForm" type="LayoutFormType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies how items appear in a PivotTable report.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="LayoutSubtotalLocation" type="LayoutSubtotalLocationType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies where subtotals are displayed in a PivotTable report.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NoDragToRow" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies that the field cannot be dragged to create column headers.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NoDragToColumn" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies that the field cannot be dragged to create row headers.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NoDragToData" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies that the field cannot be dragged to the data area.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NoDragToHide" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies that the field cannot be dragged out of the pivot area.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NoDragToPage" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies that the field cannot be dragged to the page area.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="MemberProperty" type="MemberPropertyType" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Contains additional information (member property information) about a field in OLAP-based PivotTable view or report.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="MemberPropertiesOrder" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the order of a member property if a cube field is associated with multiple OLAP member properties.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="HideDropDowns" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean value indicating whether the drop-down list for a field in the PivotTable view should be shown.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="DrilledLevel" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean that indicates for a PivotField in an OLAP-based PivotTable whether this PivotField was shown due to the user navigating down an entire hierarchy level.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="ServerSortOrder" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean that indicates for a PivotField in an OLAP-based PivotTable whether the order of the PivotItems comes from the server or is determined by Excel.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="IsMemberProperty" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean value indicating whether OLAP member property information is displayed for a field.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="CurrentPage" type="xsd:string" default="All" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the name of the PivotItem selected for this PivotField when the PivotField is in the page area.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Caption" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the display text or caption for a PivotField in an OLAP-based PivotTable.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="FilterMember" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Contains information about OLAP cube members that are selected when an OLAP hierarchy is shown in the page area of the PivotTable view.</xsd:documentation>
            </xsd:annotation>
            <xsd:complexType>
                <xsd:sequence>
                    <xsd:element name="UniqueName" type="xsd:string" minOccurs="0">
                        <xsd:annotation>
                            <xsd:documentation>Specifies a unique name for a OLAP cube member.</xsd:documentation>
                        </xsd:annotation>
                    </xsd:element>
                    <xsd:element name="Level" type="xsd:integer" minOccurs="0">
                        <xsd:annotation>
                            <xsd:documentation>Contains the zero-based level index on which an OLAP cube member resides.</xsd:documentation>
                        </xsd:annotation>
                    </xsd:element>
                    <xsd:element name="Caption" type="xsd:string" minOccurs="0">
                        <xsd:annotation>
                            <xsd:documentation>Specifies a caption for the OLAP cube member.</xsd:documentation>
                        </xsd:annotation>
                    </xsd:element>
                </xsd:sequence>
            </xsd:complexType>
        </xsd:element>
        <xsd:element name="Position" type="xsd:int" default="1" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the order of the fields when several PivotFields are used.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="DataType" type="DataTypeType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the data type of the field.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="ServerBased" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean indicating whether the server is queried every time the user changes the selected PivotItem for the PivotField that is in the page area.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="ShowAllItems" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean indicating whether all PivotItems should be shown or not even if they have no data.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="SQLType" type="SQLTypeType" default="Character" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the data type using SQL Server data types.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="SubtotalName" type="xsd:string" default="Subtotal" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the custom text to display for the subtotal label for this PivotField.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="PLTPivotItem" type="PivotItemType" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="DetailFormat" type="DetailFormatType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the text formatting that is applied to a field when it is on the detail grid.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="DetailWidth" type="xsd:int" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the width of a field (in pixels) when it appears on the detail axis.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Expanded" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether the field members are expanded by default, or whether a leaf member was expanded.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="FilterCaption" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains the caption of a field set when the field set is the current filter.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Formula" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the formula used to calculate the values for a PivotField in the data area.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="FormulaV10" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains the string of the Formula element with English locale. This string is generated only generated when the English version of the Formula string is different from the string in the Formula element.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="ParseFormulaAsV10" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies that the string in the Formula element is to be processed as if it is an English string (a V10 formula).</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="GroupedWidth" type="xsd:int" default="50" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the width of a field (in pixels) when on the grouping axis, and whether the column width of a field is set automatically when the field is used on the row or column axis.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NewItemsHidden" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean indicating whether new items from a refresh operation will be hidden by default in the PivotTable report or displayed.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="PLCaption" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the contains the caption of a PivotList field.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="PLDataOrientation" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether a field is on the detail grid.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="PLGroupType" type="xsd:string" fixed="Weeks" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether a field is the Weeks field of a weekly automatic date field set.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="PLName" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains the name of a total when a PivotField element represents a total.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="PLPosition" type="xsd:int" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the position of a field in the detail grid.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="PLSubtotal" type="xsd:double" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains the subtotal to display when a PivotTable field is not on the column or row axis.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="SourceHierarchy" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the name of the hierarchy this PivotField belongs to in an OLAP-based PivotTable.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="MemberPropertyParent" type="xsd:integer" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains an index of the hierarchy level to which a particular OLAP member property applies.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="SourceHierarchyLevel" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies a number indicating what level in the hierarchy this PivotField belongs to in an OLAP-based PivotTable.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="PivotItem" type="PivotItemType" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Contains information on an item (PivotItem) in the PivotField.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="SubtotalFormat" type="SubtotalFormatType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the text formatting that is applied to a subtotal.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="TotalAlignment" type="TotalAlignmentType" default="Automatic" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the horizontal alignment of a total.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="TotalCaptionAlignment" type="TotalCaptionAlignmentType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the horizontal alignment of the caption for a total.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="TotalWidth" type="xsd:int" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the width of a total and whether the width is automatically set.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
DataField x:DataField 0 (1)
Name x:Name (1) (1)
MapChildItems x:MapChildItems 0 (1)
AutoShowCount x:AutoShowCount 0 (1)
AutoShowField x:AutoShowField 0 (1)
AutoShowRange x:AutoShowRange 0 (1)
AutoShowType x:AutoShowType 0 (1)
AutoSortOrder x:AutoSortOrder 0 (1)
AutoSortField x:AutoSortField 0 (1)
BaseField x:BaseField 0 (1)
BaseItem x:BaseItem 0 (1)
BlankLineAfterItems x:BlankLineAfterItems 0 (1)
Calculation x:Calculation 0 (1)
CantGetUniqueItems x:CantGetUniqueItems 0 (1)
GroupBy x:GroupBy 0 (1)
GroupStart x:GroupStart 0 (1)
GroupEnd x:GroupEnd 0 (1)
GroupStartAuto x:GroupStartAuto 0 (1)
GroupEndAuto x:GroupEndAuto 0 (1)
GroupType x:GroupType 0 (1)
LayoutPageBreak x:LayoutPageBreak 0 (1)
NumberFormat x:NumberFormat 0 (1)
ParentField x:ParentField 0 (1)
SourceName x:SourceName 0 (1)
Orientation x:Orientation 0 (1)
Function x:Function 0 (1)
Subtotal x:Subtotal 0 unbounded
LayoutForm x:LayoutForm 0 (1)
LayoutSubtotalLocation x:LayoutSubtotalLocation 0 (1)
NoDragToRow x:NoDragToRow 0 (1)
NoDragToColumn x:NoDragToColumn 0 (1)
NoDragToData x:NoDragToData 0 (1)
NoDragToHide x:NoDragToHide 0 (1)
NoDragToPage x:NoDragToPage 0 (1)
MemberProperty x:MemberProperty 0 unbounded
MemberPropertiesOrder x:MemberPropertiesOrder 0 (1)
HideDropDowns x:HideDropDowns 0 (1)
DrilledLevel x:DrilledLevel 0 (1)
ServerSortOrder x:ServerSortOrder 0 (1)
IsMemberProperty x:IsMemberProperty 0 (1)
CurrentPage x:CurrentPage 0 (1)
Caption x:Caption 0 (1)
FilterMember x:FilterMember 0 unbounded
Position x:Position 0 (1)
DataType x:DataType 0 (1)
ServerBased x:ServerBased 0 (1)
ShowAllItems x:ShowAllItems 0 (1)
SQLType x:SQLType 0 (1)
SubtotalName x:SubtotalName 0 (1)
PLTPivotItem x:PLTPivotItem 0 unbounded
DetailFormat x:DetailFormat 0 (1)
DetailWidth x:DetailWidth 0 (1)
Expanded x:Expanded 0 (1)
FilterCaption x:FilterCaption 0 (1)
Formula x:Formula 0 (1)
FormulaV10 x:FormulaV10 0 (1)
ParseFormulaAsV10 x:ParseFormulaAsV10 0 (1)
GroupedWidth x:GroupedWidth 0 (1)
NewItemsHidden x:NewItemsHidden 0 (1)
PLCaption x:PLCaption 0 (1)
PLDataOrientation x:PLDataOrientation 0 (1)
PLGroupType x:PLGroupType 0 (1)
PLName x:PLName 0 (1)
PLPosition x:PLPosition 0 (1)
PLSubtotal x:PLSubtotal 0 (1)
SourceHierarchy x:SourceHierarchy 0 (1)
MemberPropertyParent x:MemberPropertyParent 0 (1)
SourceHierarchyLevel x:SourceHierarchyLevel 0 (1)
PivotItem x:PivotItem 0 unbounded
SubtotalFormat x:SubtotalFormat 0 (1)
TotalAlignment x:TotalAlignment 0 (1)
TotalCaptionAlignment x:TotalCaptionAlignment 0 (1)
TotalWidth x:TotalWidth 0 (1)
Collapse Derivation Tree:
Collapse References:
x:PivotField
Documentation for Microsoft Office 2003 Reference Schemas

Generated using Liquid Studio - Developer Bundle 21.0.0.0