🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

How aggregation values are calculated.

Ankush asked on August 16, 2019

We want to understand how in-built aggregation values(screenshot attached) are calculated by flexmonster. What formulas are used etc. Can you provide some documentation around it?

1 answer

Vera Didenko Vera Didenko Flexmonster August 16, 2019

Thank you for your question.
In Flexmonster aggregations are calculated like in Excel pivot table:

  1. Sum, Count, Distinct Count, Average, Product, Min, Max, Population StDev, Sample StDev: https://www.contextures.com/excel-pivot-table-summary-functions.html
  2. % of Grand Total, % of Column, % of Row, Difference, % of Difference, Index: https://www.contextures.com/xlPivot10.html
  3. How Running Totals work is explained in the following blog post: https://www.flexmonster.com/blog/running-totals-in-pivot-grid/

Please let us know if you have any questions.
Best Regards,

Please login or Register to Submit Answer