Forum Discussion
Solved
Difference between Column values in a Matrix
Hi, I have a simple table with a date where the user will be able to select 2 dates and see the difference in Sum of Sales value between the selected dates as shown in the screen shot below. Use...
Jihwan_Kim Thanks for the response.
I tried creating this measure and row level differences are correct but i still see issue at the grand total of the Total (Difference).
The total difference for the 2 selected dates must be 701 as per the below screenshot
(250-149+600) but the total shows -329 (Looks like this -329 is consistent no matter what dates we select)