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

PivotTable percentages
 

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



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

PivotTable percentages
 

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