Debra

Thanks for the quick response, it worked perfectly.

Steve


On Sat, 12 Aug 2006 10:54:07 -0400, Debra Dalgleish
wrote:

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