Forum Discussion

BItoken's avatar
BItoken
Icon for Helper III rankHelper III
5 years ago
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...
BItoken's avatar
BItoken
Icon for Helper III rankHelper III
5 years ago

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)