🎉 Flexmonster Pivot Table & Charts v2.8 has arrived!Read the blog post
Get Free Trial
Get Free Trial

How aggregation values are calculated.

Answered
Ankush asked on August 16, 2019

Hi,
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

Public
Vera Didenko Flexmonster August 16, 2019

Hello,
 
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,
Vera

Please login or Register to Submit Answer