I need to calculate a % based on a grouped totalin a pivot table. I've tried
calculated field & items but can't get them to work. If I use a calculated
item I get this:

Reg1 Reg2
Item1 Sales 100 200
Item2 Sales 200 300
Total Sales 300 500

Item1 Margin 50 150
Item2 Margin 100 200
Total Margin 150 350

Item1 Margin% 50% 75%
Item2 Margin% 50% 66%
Total Margin% 100% 133% When the values S/B 50% and 70%

I know this should be easy but I can't figure it out.
Thank you all very much
--
CSAHP