To display the cumulative total properly

[sajal161292]

Hi,

I am stuck while displaying the cumulative total at every point in one of my reports.

For week 47 = (-1551.55)+ 557.72 = -993.83 should get displayed

For week 48 = (-993.83)+(-130.40) = -1124.23 should get displayed and like that with the total at the end of the week

I turned ON the row and column subtotal but it is not giving me the correct result.

Any help would be much appreciated!!

Thanks 

[v-ljerr-msft]

Hi @sajal161292,

Have you tried the solution provided by @Abduvali above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?

If you still have any question on this issue, feel free to post here.

Regards

[Abduvali · Accepted solution]

Hi @sajal161292,

I think what you looking for is Running Total, try the following and see if it works for you:

Running Total MEASURE =
   CALCULATE (
                         SUM ( 'Sheet4'[Item_Rev]),
                                    FILTER (ALL ( 'Sheet4' ),'Sheet4'[Date] >= MAX ( 'Sheet4'[Date] )
                                   )
)

Regards

Abduvali