Percentages in pivot table

[Vicky]

I'm getting a little frustrated with a pivot table that I have and am hoping that someone will be able to help me.

My pivot table has three fields:

Division : Department Code : Count of people in dept codes (shown as percentage).

What I am trying to do, is for each division, the percentage for the count of people in a dept code should add to 100%. Unfortunately I can't seem to get this to happen, the subtotals for the divisions are a percentage of the whole total.

so for example:<pre>Division : Dept Code : Countofpeople (as %)
Equities : E111 : 25%
: E112 : 25%
Technology: T111 : 25%
:T112 : 25%

Total :100%</pre>

What I want to happen is:<pre>Division : Dept Code : Countofpeople (as %)
Equities : E111 : 50%
: E112 : 50%
Equities subtotal : 100%
Technology: T111 : 50%
:T112 : 50%
Technology subtotal : 100%</pre>

Thanks,
Vicky
This message was edited by Juan Pablo G. on 2002-10-10 23:03

 

[Juan Pablo González]

I would say that you have to do this calculation on the origin table and not on the pivot table.

 

[Vicky]

I'm not sure how to go about this on the origin table. sample of the data in the original table is below. For each division, I want to see the total number of each R/C as a percentage of that division, with percentages in each division adding up to 100%..

Thanks,
Vicky<pre>DIVISION OFFICE R/C
Investment Mgmt Div Hong Kong A247
Investment Mgmt Div Hong Kong A264
Investment Mgmt Div Hong Kong A264
Investment Mgmt Div Hong Kong A264
Investment Mgmt Div Hong Kong A264
Investment Mgmt Div Hong Kong A264
Investment Mgmt Div Hong Kong A264
Investment Mgmt Div Hong Kong A264
Investment Mgmt Div Hong Kong A264
Investment Mgmt Div Hong Kong A264
Investment Mgmt Div Hong Kong A264
Investment Mgmt Div Hong Kong A751
Investment Mgmt Div Hong Kong A751
Investment Mgmt Div Hong Kong A751
Investment Mgmt Div Hong Kong A751</pre>
This message was edited by Juan Pablo G. on 2002-10-11 01:06

 

[arunjhalani]

On 2002-10-10 23:08, Vicky wrote:
I'm not sure how to go about this on the origin table. sample of the data in the original table is below. For each division, I want to see the total number of each R/C as a percentage of that division, with percentages in each division adding up to 100%..

Thanks,
Vicky

DIVISION OFFICE R/C
Investment Mgmt Div Hong Kong A247
Investment Mgmt Div Hong Kong A264
Investment Mgmt Div Hong Kong A264
Investment Mgmt Div Hong Kong A264
Investment Mgmt Div Hong Kong A264
Investment Mgmt Div Hong Kong A264
Investment Mgmt Div Hong Kong A264
Investment Mgmt Div Hong Kong A264
Investment Mgmt Div Hong Kong A264
Investment Mgmt Div Hong Kong A264
Investment Mgmt Div Hong Kong A264
Investment Mgmt Div Hong Kong A751
Investment Mgmt Div Hong Kong A751
Investment Mgmt Div Hong Kong A751
Investment Mgmt Div Hong Kong A751

Can we have Department in the Column field of the Pivot table so that each department will have its count of People as the the % of the totalin the bottom of the pivot ?.
Just changing the layout of the pivot table ??

 

[Vicky]

Unfortunately that doesn't work as I want to see the percentage per division. There are about 10 divisions, each containgin a number of department numbers. I need to be able to see the department number count as a percentage of the division to which they belong - not as a percentage of the total of all divisions.

as a bit of background, I am using this as an allocation model to allocate out helpdesk tickets. The Help desk tickets are logged using the division. I need to allocate our costs out to department numbers. So to further allocate from division to dept number, I am using headcount.

Vicky