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]
- ssml:pivotArea [1..1] Calculated Item Location
- 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>