ssml:calculatedItem

Calculated Item

Element information

Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main

Schema document: sml-pivotTable.xsd

Type: ssml:CT_CalculatedItem

Properties: Local, Qualified

Content

Sequence [1..1]
1. ssml:pivotArea [1..1] Calculated Item Location
2. ssml:extLst [0..1] Future Feature Storage Area

Attributes

Name	Occ	Type	Description	Notes
field	[0..1]	xsd:unsignedInt	Field Index
formula	[0..1]	ssml:ST_Xstring	Calculated Item Formula

Used in

Type ssml:CT_CalculatedItems (Element ssml:calculatedItems)

Sample instance

<ssml:calculatedItem>
   <ssml:pivotArea>
      <ssml:references>
         <ssml:reference>...
         </ssml:reference>
      </ssml:references>
      <ssml:extLst>
         <ssml:ext>
            <!--any element-->
         </ssml:ext>
      </ssml:extLst>
   </ssml:pivotArea>
   <ssml:extLst>
      <ssml:ext>
         <!--any element-->
      </ssml:ext>
   </ssml:extLst>
</ssml:calculatedItem>