Pivot Tables: Calculated Fields

Rennie · Jul 10th 2003

Hi All,

I would like to insert a margin calculated field under my profit field in the attached example. Can someone help.

Thanks,
Rennie

Brandtrock · Jul 10th 2003

I looked at your file and got a partial solution. By adding a second set of figures in your data area and changing the field settings I got them to display as percentages of revenue - except for the totals. I don't know how to get around that part. Hopefully someone more capable can get around that. In fact, it wouldn't surprise me if somebody came up with an entirely different solution.

Good Luck!
:usaflag:

Rennie · Jul 11th 2003

Hi Brandtrock,

Thank you very much for your response. Your ideas have certainly pointed me towards the right track.

With your help I have managed to achieve what I wanted.

Please see the attached file.

Thanks again.
Rennie

Brandtrock · Jul 11th 2003

Glad you got to where you needed to be on this.

Pivot Tables: Calculated Fields

Participate now!

Share