Calculation for creating a difference between 2 time periods

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?

Hi @Vysh27
you can check out


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

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

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.


Ramon Lopez