Can I change the formula for the Grand Total?


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 Flexmonster 3 days ago

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 3 days ago

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 Flexmonster 3 days ago

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