Percentages in pivot table

Vicky

New Member
Joined
Sep 17, 2002
Messages
7
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
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Vicky

New Member
Joined
Sep 17, 2002
Messages
7
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

Board Regular
Joined
Oct 8, 2002
Messages
121
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

New Member
Joined
Sep 17, 2002
Messages
7
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
 

Forum statistics

Threads
1,143,709
Messages
5,720,391
Members
422,283
Latest member
Parvathy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top