How to show Difference of 2 columns instead of Grand Total
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.
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.