Pivot table - Measure calculation based on dimension

[manojkumargowda]

Hi Everyone,

I need to create a pivot table which is something like below.

Week

Sum of Balance for the week

Compare: Difference in balance between current week and previous week. 

How can I calculate Compare value?

Week	Balance	Compare?
15/03/2020	600	210
8/03/2020	390	180
1/03/2020	210	20
23/02/2020	190	50
16/02/2020	140	140

[joseph_morales]

Hi @manojkumargowda ,

You can create an expression on the pivot table as follows:

if(
isnull(below(sum(Balance))),
sum(Balance),
rangesum(sum(Balance)-below(sum(Balance)))
)

[MichalSa]

Thanks! I had the same question and your answer was helpful!

If I also want calculate the difference between the previous 2 weeks from current - how would I do that?

Below ( below ( sum balance))?