Pivot Table % of Total

[howard]

I have attached a Pivot Table of my data below. I would like to have a new column next to each party to compute % votes per age category as % of Total.

For Eg Age 18-24 ACDP = 4/251

I would also like a row below the grand total to compute the No of votes per Pary as as % of the total for eg ACDP 41/4000

Your assistance in helping me resolve this on a Pivot Table is most appreciated

Chapter 10 Pivot Table Grouping.xls
	A	B	C	D	E	F	G
3	CountofVOTER	PARTY
4	Age	ACDP	ANC	COPE	DA	PAC	GrandTotal
5	18-24	4	62	3	141	41	251
6	25-31		6	2	9	2	19
7	32-38	9	105	10	209	81	414
8	39-45	9	137	10	261	73	490
9	46-52	7	185	11	327	134	664
10	53-59	8	257	11	558	125	959
11	60-66	2	176	8	330	52	568
12	67-73	1	199	4	256	35	495
13	74-80	1	52	2	78	7	140
14	GrandTotal	41	1179	61	2169	550	4000
Pivot Table Group

 

[Robert Mika]

First question:

Not sure about version of Excel prior to 2007 but in 07 and 10
Cick on the Pivot go to PivotTableTolls Option Ribbon-->Calcualtions--Field,Items&Sets-->Calcualted Field.
In the "Formula" field you need to choose which columns needs to be calculated.
To example:
=ACDP/ Total

That will give you % of Total for ACDP.

Second question:
Probably for this you will have use normal formula as I do not know any way to do it in PivotTable (unless you add this row to your RAW data)

 

[howard]

Hi Robert

Thanks for the help, much appreciated