Calculate Actual Value from Cumulative Values

[Shahzad_Ahsan]

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

[Anil_Babu_Samineni]

Perhaps this?

If(Category=Above(Category), Sum(Value)-Above(Sum(Value)), Sum(Value))

[Shahzad_Ahsan]

Hi 

No, this is not working

if I sort the column by Category or date, the expected value changes.