Solved: Pivot Table:Percentage of sub-totals?

[Slicemahn]

Hello Everyone,
Is there a way in which I can use Excel's Pivot Table function to calculate percentage of subtotals? I have attached a spreadsheetas an illustration. I have gone through most of the items in the field options with no success.

I would appreciate any suggestions on handling this.

Thanks
Slice

[rory]

You would need to rearrange your data as in the attached file.

[Slicemahn]

Thanks Rory. I was hoping for a solution in its present format.

[rory]

You would have to use formulas outside the pivot table for that.

[Bob Phillips]

Calculated in the data