Pricing changes are coming in January. Contact our Sales team to secure the current price for your desired license.
Get Free Trial
Get Free Trial

Definitions behind items listed in Select Aggregations

posted on April 6th, 2021

Answered
Georgie Kourkounakis asked on April 6, 2021

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

3 answers

Public
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. https://www.contextures.com/excel-pivot-table-summary-functions.html - Sum, Count, Distinct Count, Average, Product, Min, Max, Population StDev, Sample StDev aggregations.
  2. https://www.contextures.com/xlPivot10.html - % of Grand Total, % of Column, % of Row, Difference, % of Difference, Index.
  3. https://www.flexmonster.com/blog/running-totals-in-pivot-grid/ - Running Totals.

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

Public
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. 

Public
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,
Milena

Please login or Register to Submit Answer