Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have data in cumulative form. I need to calculate the actual difference
My Table is like this:
Category | Date | Value |
A | 03/12/2019 | 968 |
B | 03/12/2019 | 478 |
C | 03/12/2019 | 259 |
D | 03/12/2019 | 478 |
A | 04/12/2019 | 970 |
B | 04/12/2019 | 481 |
C | 04/12/2019 | 261 |
D | 04/12/2019 | 490 |
A | 05/12/2019 | 980 |
B | 05/12/2019 | 490 |
C | 05/12/2019 | 270 |
D | 05/12/2019 | 500 |
I need Result like this
Category | Date | Value | Result |
A | 03/12/2019 | 968 | 968 |
B | 03/12/2019 | 478 | 478 |
C | 03/12/2019 | 259 | 259 |
D | 03/12/2019 | 478 | 478 |
A | 04/12/2019 | 970 | 2 |
B | 04/12/2019 | 481 | 3 |
C | 04/12/2019 | 261 | 2 |
D | 04/12/2019 | 490 | 12 |
A | 05/12/2019 | 980 | 10 |
B | 05/12/2019 | 490 | 9 |
C | 05/12/2019 | 270 | 9 |
D | 05/12/2019 | 500 | 10 |
Perhaps this?
If(Category=Above(Category), Sum(Value)-Above(Sum(Value)), Sum(Value))
Hi
No, this is not working
if I sort the column by Category or date, the expected value changes.