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

Can I change the formula for the Grand Total?

Joe Hauck asked on April 17, 2019

Here’s a sample I’ve attached. So, if I ask it to show grand totals, it sums up the columns for both the dates. But, I would want to do a difference instead of sum. Please, let me know if there’s any way I could achieve this.


3 answers

Dmytro Zvazhii Dmytro Zvazhii Flexmonster April 17, 2019

Hello Joe,
Thank you for posting your question here. 
Yes, you are right. Grand Total uses sum aggregation by default.
Currently, there is no option for changing the aggregation formula of Grand Total.
Please let us know in case of any other question.

Joe Hauck April 17, 2019

Thanks for the quick reply Dmytro!

So, based on the attachment that I had sent you on my previous message, do you think you could help me figure out how can I achieve the difference of those two columns as a separate column?


Vera Didenko Vera Didenko Flexmonster April 18, 2019

Hello, Joe,

Thank you for your question.

Here is a JSFiddle example illustrating how to display the difference between two columns.
Please note that this is the closest to the desired output solution available at the moment. 

You can display only difference if desired, by excluding the sum row.

Please let us know if this works for you and if you have further questions.
Best Regards,

Please login or Register to Submit Answer