How to show Difference of 2 columns instead of Grand Total

posted on July 26th, 2019

Answered

Andrew W asked July 26, 2019

Hi,
Just discovered this great product. Playing around with it.
How do I show the Difference of 2 columns instead of Grand Total. I know there’s a Aggregation of Difference but that will make the 2 columns disappear. Eg, I have data sum of Amount for years 2018 and 2019 in 2 columns, how do i show the difference of the 2 years in the Total Column of each row?
Thanks in advance.
ANDREWW

1 answer

WebDataRocks Team ⋅ WebDataRocks ⋅ July 31, 2019

Hello Andrew,

Thank you for the question.
Seems you can achieve the described above by slightly reorganizing your data and using Calculated Values. Please see the example: https://codepen.io/webdatarocks/pen/vomVWE
Hope it helps.

Regards,
WebDataRocks Team

Move up