🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

ADD: Custom aggregation formula.

Alfonso Davide Pilato asked on March 13, 2019

Hi guys, 
my name is Alfonso Davide Pilato. I work as software developer in Italy. 
I am very interested in buying your component, but I would like to know if there is the possibility of inserting a custom aggregation formula
I await an answer.

3 answers

Vera Didenko Vera Didenko Flexmonster March 14, 2019

Hello Alfonso Davide Pilato,

Thank you for your question.

Could you please give us more details about which formulas you would like to implement in Flexmonster?

We are looking forward to hearing from you.

Best Regards,

Alfonso Davide Pilato March 14, 2019

Hello Vera, 
Thank you for your answer,
I try to describe my problem better:
In the first attached file: I have a table with a column and aggregated measurements where the turnover is a calculated value (price * quantity). 
As you can see there is a problem on the sum of the price, I would like it to be calculated with a formula ( sum(turnover) / sum(quantity) ) weighted average .
The sum of the aggregate price measure does not make much sense.
I hope I was clear
Best Regards,


Vera Didenko Vera Didenko Flexmonster March 15, 2019

Hello Alfonso,

Thank you for specifying your needs.

You can achieve the desired output by using calculated values.

Here is a JSFiddle demonstrating the solution for the problem you described.

Please let us know if everything works fine for you and if you have further questions.

Best Regards,

Please login or Register to Submit Answer