Calculation for creating a difference between 2 time periods

Q&A
, ,
1

Hi Community , I’m trying to create a calculation which gives the difference of value between 2 time periods
How can i achieve it?Any suggestions?
image

2

Hi @Vysh27
you can check out

BR

3

Hey @ErikG
I’ve done the calculation , But I want the column next to score difference column instead of all the 3
How do i do it
image

4

What comes up first is a second pivot table with only the difference column and not the two others.

5

Hi @Vysh27

Did @ErikG suggestion of using multiple pivot tables work?

Created a quick example using Arena. In my approach i used ifelse functions and various calculated fields to get to what i think you were calculating. See blow and feel free to explore analysis to see how i did it.

triplepivot

Regards,
Ramon Lopez