View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve Simons Steve Simons is offline
external usenet poster
 
Posts: 15
Default PivotTable percentages

Help please!

I have data for a company from which I create a PT. The data is
similar to below

DEPT NAME GENDER SALARY BONUS

Admin fred M 15,555 250
Admin sue F 15,555 750
Accs Fiona F 20,999 150
Security Ellie F 18,943 950
Accs Joe M 21,000 1200

Basically I have created a PT that shows me the percentage earnings
and bonus for each gender against the grand total. (I used the 'pivot
table field' Options Show Data As % of Total option')

I would also like to show the percentage that each gender's salary &
bonus is of the departmental total.

For example, from the data above I would see that the Admin percentage
would be 50% for M & F; the bonus would be 25% for M & 75% for F.

I hope that's clear enough. Let me know if you want more info.

I've tried the % of Row & % of Column options, but there's obviously
something I'm missing!

TIA

Steve