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

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

Debra

Thanks for the quick response, it worked perfectly.

Steve


On Sat, 12 Aug 2006 10:54:07 -0400, Debra Dalgleish
<dsd@contexturesXSPAM.com> 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
>>