# need to calculate:Pivot Table % calculation

1. ## need to calculate:Pivot Table % calculation

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

2. ## re: need to calculate:Pivot Table % calculation

The subtotals in the pivot table will all use the same function -- in
this case they're all SUM functions. You could use conditional
formatting to hide the Total Margin% row, and do your own calculation
outside of the pivot table.

CSAH wrote:
> 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

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1