PivotTable percentages

[Steve Simons]

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

 

[Debra Dalgleish]

With Dept in the Row area and Gender in the Column area, add Salary and
Bonus to the data area.
Set each data field to show the % of Row
The Grand Total row will show overall percentages.

 

[Steve Simons]

Debra

Thanks for the quick response, it worked perfectly.

Steve