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.
Thanks!
⋅ 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.
Regards,
Dmytro
⋅ 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?
Thanks!
⋅ 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,
Vera
