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?
⋅ August 16, 2019
Hello,
Thank you for your question.
In Flexmonster aggregations are calculated like in Excel pivot table:
Sum, Count, Distinct Count, Average, Product, Min, Max, Population StDev, Sample StDev: https://www.contextures.com/excel-pivot-table-summary-functions.html% of Grand Total, % of Column, % of Row, Difference, % of Difference, Index: https://www.contextures.com/xlPivot10.htmlRunning 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