russlindell
New Member
Is there a way to calculate the difference in values between different columns of a pivot table?
For example, what would be the best way to find the difference in an employees performance between Q3 and Q4 or between Q4 and the average of Q1, Q2 and Q3?
Thanks for any help.
For example, what would be the best way to find the difference in an employees performance between Q3 and Q4 or between Q4 and the average of Q1, Q2 and Q3?
Thanks for any help.
Code:
Q1 Q2 Q3 Q4 | Q4-Q3 | Q4 - AVG(Q1, Q2, Q3)
emp01 50 25 33 40 | 7 | ###
emp02 30 35 23 50 | 27 | ###
emp03 55 20 63 20 | -43 | ###