Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
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