Documentation for Microsoft Office 2003 Reference Schemas
Definition Type: ComplexType
Name: PivotTableType
Namespace: urn:schemas-microsoft-com:office:excel
Containing Schema: excel.xsd
Abstract
Documentation:
Contains information on a PivotTable.
Collapse XSD Schema Diagram:
Drilldown into PTFormat in schema excel_xsd Drilldown into PTFormula in schema excel_xsd Drilldown into PTSource in schema excel_xsd Drilldown into PTLineItems in schema excel_xsd Drilldown into CalculatedMember in schema excel_xsd Drilldown into CubeField in schema excel_xsd Drilldown into PivotField in schema excel_xsd Drilldown into DefaultVersion in schema excel_xsd Drilldown into VersionRefreshableMin in schema excel_xsd Drilldown into VersionLastUpdate in schema excel_xsd Drilldown into VersionUpdateableMin in schema excel_xsd Drilldown into PivotAxis in schema excel_xsd Drilldown into FieldListLeft in schema excel_xsd Drilldown into FieldListRight in schema excel_xsd Drilldown into FieldListBottom in schema excel_xsd Drilldown into FieldListTop in schema excel_xsd Drilldown into CacheDetails in schema excel_xsd Drilldown into ConnectionString in schema excel_xsd Drilldown into MemberExpand in schema excel_xsd Drilldown into MaxWidth in schema excel_xsd Drilldown into MaxHeight in schema excel_xsd Drilldown into Width in schema excel_xsd Drilldown into Height in schema excel_xsd Drilldown into NoAutoFit in schema excel_xsd Drilldown into DisplayFieldList in schema excel_xsd Drilldown into DataAxisEmpty in schema excel_xsd Drilldown into DataMember in schema excel_xsd Drilldown into PLTotal in schema excel_xsd Drilldown into PLPivotField in schema excel_xsd Drilldown into Location in schema excel_xsd Drilldown into VisualTotals in schema excel_xsd Drilldown into NoViewCalculatedMembers in schema excel_xsd Drilldown into HideDropDowns in schema excel_xsd Drilldown into ShowCellBackgroundFromOLAP in schema excel_xsd Drilldown into HideTotalsAnnotation in schema excel_xsd Drilldown into VacatedStyle in schema excel_xsd Drilldown into Tag in schema excel_xsd Drilldown into TableStyle in schema excel_xsd Drilldown into SmallGrid in schema excel_xsd Drilldown into ShowPageMultipleItemLabel in schema excel_xsd Drilldown into ImmediateItemsOnDrop in schema excel_xsd Drilldown into PLExport in schema excel_xsd Drilldown into PageFieldStyle in schema excel_xsd Drilldown into MergeLabels in schema excel_xsd Drilldown into PrintSetTitles in schema excel_xsd Drilldown into GrandTotalString in schema excel_xsd Drilldown into AutoFormatPattern in schema excel_xsd Drilldown into AutoFormatNumber in schema excel_xsd Drilldown into AutoFormatName in schema excel_xsd Drilldown into AutoFormatFont in schema excel_xsd Drilldown into AutoFormatBorder in schema excel_xsd Drilldown into AutoFormatAlignment in schema excel_xsd Drilldown into Selection in schema excel_xsd Drilldown into PivotView in schema excel_xsd Drilldown into NoPrintRepeatItems in schema excel_xsd Drilldown into NoDisplayNullString in schema excel_xsd Drilldown into NoColumnGrand in schema excel_xsd Drilldown into NoRowGrand in schema excel_xsd Drilldown into NoAutoFormatWidth in schema excel_xsd Drilldown into SubtotalHiddenPageItems in schema excel_xsd Drilldown into HasNoAutoFormat in schema excel_xsd Drilldown into NoPreserveFormatting in schema excel_xsd Drilldown into DisplayErrorString in schema excel_xsd Drilldown into DisableWizard in schema excel_xsd Drilldown into DisableFieldDialog in schema excel_xsd Drilldown into DisableDrillDown in schema excel_xsd Drilldown into PageFieldWrapCount in schema excel_xsd Drilldown into PageFieldOrder in schema excel_xsd Drilldown into NullString in schema excel_xsd Drilldown into ErrorString in schema excel_xsd Drilldown into QTSource in schema excel_xsd Drilldown into DataValueEditing in schema excel_xsd Drilldown into Name in schema excel_xsdXSD Diagram of PivotTableType in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code: 
<xsd:complexType name="PivotTableType">
    <xsd:annotation>
        <xsd:documentation>Contains information on a PivotTable.</xsd:documentation>
    </xsd:annotation>
    <xsd:sequence>
        <xsd:element name="Name" type="xsd:string">
            <xsd:annotation>
                <xsd:documentation>Specifies the name of the PivotTable.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="DataValueEditing" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean value indicating that the user is allowed to edit the cells in the data area of the PivotTable view or report.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="QTSource" type="QTSourceType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Describes the properties of the query table on which a PivotTable view or report is based.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="ErrorString" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the string to display in cells with errors. Used in conjunction with DisplayErrorString.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NullString" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the string to display in cells with no value. Used in conjunction with NoDisplayNullString.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="PageFieldOrder" type="PageFieldOrderType" default="DownThenOver" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains an enumeration indicating how the page fields are laid out when there are multiple PivotFields in the page area.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="PageFieldWrapCount" type="PageFieldWrapCountType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies a number indicating how many page fields to display before starting another row or column.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="DisableDrillDown" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean indicating if the user is prevented from drilling down (double clicking) on a PivotItem or aggregate value.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="DisableFieldDialog" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean indicating if the user is prevented from displaying the PivotField properties dialogs.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="DisableWizard" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean indicating if the user is prevented from displaying the PivotTable Wizard.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="DisplayErrorString" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Causes the ErrorString to be displayed. Used in conjunction with ErrorString.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NoPreserveFormatting" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean indicating whether the formatting applied by the user to the PivotTable cells is discarded on refresh.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="HasNoAutoFormat" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean indicating whether autoformatting has been applied to the PivotTable view. Used in conjunction with AutoFormatName, AutoFormatNumber, AutoFormatBorder, AutoFormatPattern, AutoFormatAlignment and NoAutoFormatWidth.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="SubtotalHiddenPageItems" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies that data for hidden PivotItems for PivotFields in the data area are not excluded from subtotals.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NoAutoFormatWidth" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies that column widths from the style specified in the AutoFormatName element are not to be applied.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NoRowGrand" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean indicating if no grand totals should be displayed for the PivotTable rows.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NoColumnGrand" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean indicating if no grand totals should be displayed for the PivotTable columns.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NoDisplayNullString" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean indicating whether the custom NULL string should not be displayed. Used in conjunction with NullString.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NoPrintRepeatItems" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean indicating whether PivotItem names should be repeated at the top of each printed page.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="PivotView" type="PivotViewType" minOccurs="0">
            <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="Selection" type="SelectionType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains information about the current PivotTable selection.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="AutoFormatAlignment" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies that alignments from the style defined in the AutoFormatName element are to be applied.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="AutoFormatBorder" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies that border settings from the style defined in the AutoFormatName element are to be applied.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="AutoFormatFont" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies that fonts from the style defined in the AutoFormatName element are to be applied.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="AutoFormatName" type="AutoFormatNameType" default="PivotTableClassic" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the name of the built-in format to be applied.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="AutoFormatNumber" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies that number formatting from the style defined in the AutoFormatName element is to be applied.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="AutoFormatPattern" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies that the pattern from the style defined in the AutoFormatName element is to be applied.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="GrandTotalString" type="xsd:string" default="Grand Total" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the string to be displayed for grand totals.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="PrintSetTitles" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the row and column titles from the PivotTable to be printed (rather than the titles from the spreadsheet).</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="MergeLabels" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies that row or column titles that span multiple cells should be merged into a single cell.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="PageFieldStyle" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the name of the Excel style to apply to each of the PivotField-PivotItem headers displayed in the page area.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="PLExport" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean indicating whether the PivotTable was created by the Office Web Components PivotList control.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="ImmediateItemsOnDrop" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies that the PivotTable view is to be immediately updated when new items are dropped into it.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="ShowPageMultipleItemLabel" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the text to display for the PivotItem header in the page area when two or more PivotItems, but not all PivotItems, have been selected.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="SmallGrid" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean indicating if a PivotTable view without a data field should show the small grid, which doesn't have very big drop areas.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="TableStyle" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the name of the Excel style to apply to the main table area of the PivotTable.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Tag" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies a user-defined string that is associated with this PivotTable.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="VacatedStyle" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the name of the Excel style to apply to the cells left blank when a PivotTable shrinks during a refresh operation.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="HideTotalsAnnotation" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies that asterisks be displayed in subtotals and totals when visual totals are not used in OLAP-based PivotTable views.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="ShowCellBackgroundFromOLAP" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean value indicating that a PivotTable based on an OLAP source should format the data and aggregate cells in the PivotTable view using the background color from the OLAP source.</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 lists for the fields in the PivotTable view should be shown.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NoViewCalculatedMembers" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean value indicating whether calculated members should be hidden in a PivotTable view or report.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="VisualTotals" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Indicates that totals should be based on visible data only for OLAP-based PivotTable views.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Location" type="xsd:string">
            <xsd:annotation>
                <xsd:documentation>Specifies the bounding cell reference the PivotTable occupies including the page area.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="PLPivotField" type="PLPivotFieldType" 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="PLTotal" type="PLTotalType" 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="DataMember" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether the data source of a PivotList component is data from Microsoft Excel that was saved to a Web page or data from a Data Source Control component.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="DataAxisEmpty" minOccurs="0">
            <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="DisplayFieldList" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean indicating that the PivotField list window should not be shown.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NoAutoFit" minOccurs="0">
            <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="Height" type="xsd:double" minOccurs="0">
            <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="Width" type="xsd:double" minOccurs="0">
            <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="MaxHeight" type="xsd:double" default="32000" minOccurs="0">
            <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="MaxWidth" type="xsd:double" default="32000" minOccurs="0">
            <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="MemberExpand" type="MemberExpandType" minOccurs="0">
            <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="ConnectionString" type="xsd:string" minOccurs="0">
            <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="CacheDetails" type="CacheDetailsType" default="True" minOccurs="0">
            <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="FieldListTop" type="xsd:int" minOccurs="0">
            <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="FieldListBottom" type="xsd:int" minOccurs="0">
            <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="FieldListRight" type="xsd:int" minOccurs="0">
            <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="FieldListLeft" type="xsd:int" minOccurs="0">
            <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="PivotAxis" type="PivotAxisType" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Specifies additional information about a PivotTable axis or location.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="VersionUpdateableMin" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a number indicating the earliest version of Excel that can update this PivotTable view.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="VersionLastUpdate" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a number indicating which version of Excel last updated this PivotTable view.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="VersionRefreshableMin" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a number indicating the earliest version of Excel that can refresh this PivotTable view.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="DefaultVersion" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a number indicating what version of Excel was used to create this PivotTable view.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="PivotField" type="PivotFieldType" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Contains information about a PivotField.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="CubeField" type="CubeFieldType" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Contains information about a cube field (a hierarchy in an OLAP-based PivotTable view).</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="CalculatedMember" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains information about a calculated member in an OLAP-based PivotTable view or report.</xsd:documentation>
            </xsd:annotation>
            <xsd:complexType>
                <xsd:sequence>
                    <xsd:element name="Name" type="xsd:string" minOccurs="0">
                        <xsd:annotation>
                            <xsd:documentation>Specifies the name of the OLAP calculated member.</xsd:documentation>
                        </xsd:annotation>
                    </xsd:element>
                    <xsd:element name="MemberName" type="xsd:string" minOccurs="0">
                        <xsd:annotation>
                            <xsd:documentation>Specifies a caption (display name) for the custom OLAP calculated member (not used for sets).</xsd:documentation>
                        </xsd:annotation>
                    </xsd:element>
                    <xsd:element name="ParentUniqueName" type="xsd:string" minOccurs="0">
                        <xsd:annotation>
                            <xsd:documentation>Specifies a unique name for the parent member of the OLAP calculated member (not used for sets).</xsd:documentation>
                        </xsd:annotation>
                    </xsd:element>
                    <xsd:element name="SourceHierarchy" type="xsd:string" minOccurs="0">
                        <xsd:annotation>
                            <xsd:documentation>Specifies a unique name for the hierarchy with which the OLAP calculated member is associated (not used for sets).</xsd:documentation>
                        </xsd:annotation>
                    </xsd:element>
                    <xsd:element name="SourceHierarchyLevel" type="xsd:integer" minOccurs="0">
                        <xsd:annotation>
                            <xsd:documentation>Contains an index of the hierarchy level to which a particular OLAP member property applies. A value of 32767 indicates that the OLAP member property applies to all the levels in a hierarchy.</xsd:documentation>
                        </xsd:annotation>
                    </xsd:element>
                    <xsd:element name="Formula" type="xsd:string" minOccurs="0">
                        <xsd:annotation>
                            <xsd:documentation>Contains the MDX representation of the formula for the OLAP calculated member.</xsd:documentation>
                        </xsd:annotation>
                    </xsd:element>
                    <xsd:element name="SolveOrder" type="xsd:integer" minOccurs="0">
                        <xsd:annotation>
                            <xsd:documentation>Specifies where in a sequence of calculations a calculated member will be computed and applied.</xsd:documentation>
                        </xsd:annotation>
                    </xsd:element>
                    <xsd:element name="Invalid" minOccurs="0">
                        <xsd:annotation>
                            <xsd:documentation>Contains a Boolean value indicating that the OLAP cube changed in such a way as to invalidate the OLAP calculated member.</xsd:documentation>
                        </xsd:annotation>
                    </xsd:element>
                    <xsd:element name="Set" minOccurs="0">
                        <xsd:annotation>
                            <xsd:documentation>Contains a Boolean value indicating that a calculation creates a custom OLAP set.</xsd:documentation>
                        </xsd:annotation>
                    </xsd:element>
                </xsd:sequence>
            </xsd:complexType>
        </xsd:element>
        <xsd:element name="PTLineItems" type="PTLineItemsType" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Contains information describing the detailed layout of a PivotTable view.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="PTSource" type="PTSourceType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains information describing the data source of the PivotTable view.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="PTFormula" type="PTFormulaType" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Contains information describing a PivotTable formula that doesn't apply to a whole PivotField or all PivotItems with the same name.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="PTFormat" type="PTFormatType" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Contains information describing some formatting applied to the PivotTable view.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
Name x:Name (1) (1)
DataValueEditing x:DataValueEditing 0 (1)
QTSource x:QTSource 0 (1)
ErrorString x:ErrorString 0 (1)
NullString x:NullString 0 (1)
PageFieldOrder x:PageFieldOrder 0 (1)
PageFieldWrapCount x:PageFieldWrapCount 0 (1)
DisableDrillDown x:DisableDrillDown 0 (1)
DisableFieldDialog x:DisableFieldDialog 0 (1)
DisableWizard x:DisableWizard 0 (1)
DisplayErrorString x:DisplayErrorString 0 (1)
NoPreserveFormatting x:NoPreserveFormatting 0 (1)
HasNoAutoFormat x:HasNoAutoFormat 0 (1)
SubtotalHiddenPageItems x:SubtotalHiddenPageItems 0 (1)
NoAutoFormatWidth x:NoAutoFormatWidth 0 (1)
NoRowGrand x:NoRowGrand 0 (1)
NoColumnGrand x:NoColumnGrand 0 (1)
NoDisplayNullString x:NoDisplayNullString 0 (1)
NoPrintRepeatItems x:NoPrintRepeatItems 0 (1)
PivotView x:PivotView 0 (1)
Selection x:Selection 0 (1)
AutoFormatAlignment x:AutoFormatAlignment 0 (1)
AutoFormatBorder x:AutoFormatBorder 0 (1)
AutoFormatFont x:AutoFormatFont 0 (1)
AutoFormatName x:AutoFormatName 0 (1)
AutoFormatNumber x:AutoFormatNumber 0 (1)
AutoFormatPattern x:AutoFormatPattern 0 (1)
GrandTotalString x:GrandTotalString 0 (1)
PrintSetTitles x:PrintSetTitles 0 (1)
MergeLabels x:MergeLabels 0 (1)
PageFieldStyle x:PageFieldStyle 0 (1)
PLExport x:PLExport 0 (1)
ImmediateItemsOnDrop x:ImmediateItemsOnDrop 0 (1)
ShowPageMultipleItemLabel x:ShowPageMultipleItemLabel 0 (1)
SmallGrid x:SmallGrid 0 (1)
TableStyle x:TableStyle 0 (1)
Tag x:Tag 0 (1)
VacatedStyle x:VacatedStyle 0 (1)
HideTotalsAnnotation x:HideTotalsAnnotation 0 (1)
ShowCellBackgroundFromOLAP x:ShowCellBackgroundFromOLAP 0 (1)
HideDropDowns x:HideDropDowns 0 (1)
NoViewCalculatedMembers x:NoViewCalculatedMembers 0 (1)
VisualTotals x:VisualTotals 0 (1)
Location x:Location (1) (1)
PLPivotField x:PLPivotField 0 unbounded
PLTotal x:PLTotal 0 unbounded
DataMember x:DataMember 0 (1)
DataAxisEmpty x:DataAxisEmpty 0 (1)
DisplayFieldList x:DisplayFieldList 0 (1)
NoAutoFit x:NoAutoFit 0 (1)
Height x:Height 0 (1)
Width x:Width 0 (1)
MaxHeight x:MaxHeight 0 (1)
MaxWidth x:MaxWidth 0 (1)
MemberExpand x:MemberExpand 0 (1)
ConnectionString x:ConnectionString 0 (1)
CacheDetails x:CacheDetails 0 (1)
FieldListTop x:FieldListTop 0 (1)
FieldListBottom x:FieldListBottom 0 (1)
FieldListRight x:FieldListRight 0 (1)
FieldListLeft x:FieldListLeft 0 (1)
PivotAxis x:PivotAxis 0 unbounded
VersionUpdateableMin x:VersionUpdateableMin 0 (1)
VersionLastUpdate x:VersionLastUpdate 0 (1)
VersionRefreshableMin x:VersionRefreshableMin 0 (1)
DefaultVersion x:DefaultVersion 0 (1)
PivotField x:PivotField (1) unbounded
CubeField x:CubeField 0 unbounded
CalculatedMember x:CalculatedMember 0 (1)
PTLineItems x:PTLineItems 0 unbounded
PTSource x:PTSource 0 (1)
PTFormula x:PTFormula 0 unbounded
PTFormat x:PTFormat 0 unbounded
Collapse Derivation Tree:
Collapse References:
x:PivotTable
Documentation for Microsoft Office 2003 Reference Schemas

Generated using Liquid Studio - Developer Bundle 21.0.0.0