Pivot Schema

Pivot
PivotName
[PivotJsPlugins]
[Rows]
[Columns]
[Filters]
[Measures]
[Sorts]
[Formats]
[MeasuingDimension]
[ChartsEnabled]
[ChartsActive]
[ChartType]
[ExpandAll]
[AutoCollapse]
[PrintEnabled]
[ExportEnabled]
[ShowGrandTotals]
[DecimalPlaces]
[MaxDecimalPlaces]
[MaxSymbols]
[CurrencySymbol]
[CurrencySymbolAlign]

You can define your pivot in the above element sequence. Element inside [] are optional elements. Read below to understand the detailed schema.

• Pivot Name

• Pivot Js Plugins

• Rows

• Columns

• Filters

• Measures

• Sorts

• Formats

• Measuring Dimension

• Charts Enabled

• Charts Active

• Chart Type

• Expand All

• Auto Collapse

• Print Enabled

• Export Enabled

• Show Grand Totals

• Decimal Places

• Max Decimal Places

• Max Symbols

• Currency Symbol

• Currency Symbol Align