CalculationPivotFieldType simpleType

Contains an enumeration indicating the type of calculation being done for the PivotField which is in the data area of the PivotTable report.

Type Information

Namespace urn:schemas-microsoft-com:office:excel
Schema name XML Spreadsheet 2000

Definition

      
<xsd:simpleType name="CalculationPivotFieldType" >
  <xsd:restriction base="xsd:string">
    <xsd:enumeration value="DifferenceFrom" />
    <xsd:enumeration value="Index" />
    <xsd:enumeration value="Normal" />
    <xsd:enumeration value="PercentDifferenceFrom" />
    <xsd:enumeration value="PercentOf" />
    <xsd:enumeration value="PercentOfColumn" />
    <xsd:enumeration value="PercentOfRow" />
    <xsd:enumeration value="PercentOfTotal" />
    <xsd:enumeration value="RunningTotalIn" />
  </xsd:restriction>
</xsd:simpleType>


    
©2003-2004 Microsoft Corporation. All rights reserved. Permission to copy, display and distribute this document is available at: http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp