Hi,
I have a problem that I can't seem to figure out.
I have a list with job grades and am trying to calculate difference in sallary for men and women. As it is today I have calculated this outside the Pivot table but would like to have the formula inside the pivot. As my skills in Pivot is very limited I've tried to use "Calculated Field" but with no success. Se picture below how I have structred it today, the yellw fields are the calculations I've done outside the pivot table (formals are shown below each of the 2 cells).
Any ideas how I can include this within the pivot table as formuals? Or any other ideas how to solve this?
/Per
I have a problem that I can't seem to figure out.
I have a list with job grades and am trying to calculate difference in sallary for men and women. As it is today I have calculated this outside the Pivot table but would like to have the formula inside the pivot. As my skills in Pivot is very limited I've tried to use "Calculated Field" but with no success. Se picture below how I have structred it today, the yellw fields are the calculations I've done outside the pivot table (formals are shown below each of the 2 cells).
Any ideas how I can include this within the pivot table as formuals? Or any other ideas how to solve this?

/Per