Need a special offer?Find out if your project fits.

Definitions behind items listed in Select Aggregations

Georgie Kourkounakis asked on April 6, 2021

How are you today? I'm looking for supporting documentation to tell me exactly how the items listed under the Select Aggregations icon are calculated. (Select Add Calculated Value button in Pivot table. I'm referring to the functions listed under the Select Aggregations Epsilon icon.)
Does such documentation exist, and where can access this information?  
Thank you, 

3 answers

Milena Pechura Milena Pechura Flexmonster April 6, 2021

Hello, Georgie,
Thank you for posting to our forum.
We would like to inform you that aggregations in Flexmonster are calculated as in the Excel pivot table. Our team collected some links for your reference, please find them below.

  1. - Sum, Count, Distinct Count, Average, Product, Min, Max, Population StDev, Sample StDev aggregations.
  2. - % of Grand Total, % of Column, % of Row, Difference, % of Difference, Index.
  3. - Running Totals.

Please let us know if our answer helped.
Do not hesitate to contact us in case further questions arise.
Best regards,

Georgie Kourkounakis April 8, 2021

Hello Melina, 
Thank you so much for the prompt response. To answer your question, yes. The content that you provided does answer my questions. 
Thank you! I appreciate your help. 
Georgie K. 

Milena Pechura Milena Pechura Flexmonster April 9, 2021

Hi, Georgie,
Thank you for the feedback.
We are glad to hear that our answer helped.
Feel free to reach out to us if any further questions arise.
Kind regards,

Please login or Register to Submit Answer