How to show Difference of 2 columns instead of Grand Total

Answered

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

Please login or Register to Submit Answer