Support for the GetPivotData function - PivotTable Calculations

[JanKallman]

Calculation of pivot tables:

Calculating Data Fields on rows and columns:

• Functions:

  • Sum
  • Count
  • Average
  • Min
  • Max
  • Product
  • Count Numbers
  • StdDev
  • StdDevP- Var
  • VarP

• Show Value As

  • % of Grand Total
  • % of Column Total
  • % of Row Total
  • % Of
  • % of Parent Row Total
  • % of Parent Column Total
  • % of Parent Total
  • Difference From
  • % Difference From
  • Running Total in
  • % Running Total in
  • Rank smallest to largest
  • Rank largest to smallest
  • Index

• Sorting

• Page fields

• Filters

  • Caption filters
  • Numeric Filters
  • Date & Time Filters
  • Value Filters
  • Top/bottom filters
  • Slicers

• Calculated Fields

New Functions and Properties

• ExcelPivotTable.Calculate method
• ExcelPivotTable.GetPivotData method
• ExcelPivotTable.IsCalculated property ExcelFunction.IsAllowedInCalculatedPivotTableField property