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