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