pivot subtraction question

[#1]

Hello,

I like to know if it’s possible to add new column into pivot table that will show me the gap between day1 to day2 to day3 and so on.

in the enclosed file you can see the "base" table that i have in the QV and I add the "expected" table that I like to see.

Thanks in advance.

[Anonymous]

Did you try something like:

Below(Sum(Player)) - Sum(Player)

?

[Anonymous]

See attached file:

Here I used :

SUM(field) - Below(column(1))

I hope it is helpfull
Good Luck.

[#4]

thank you both, it was very helpful.