# Percentages in pivot table

#### Vicky

##### New Member
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

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
I would say that you have to do this calculation on the origin table and not on the pivot table.

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

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 ??

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

Replies
0
Views
377
Replies
3
Views
780
Replies
0
Views
1K
Replies
1
Views
309
Replies
4
Views
443

1,219,581
Messages
6,149,119
Members
450,861
Latest member
metcala

### 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.

### Which adblocker are you using?

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

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