Pivot Table calculated field

[Kevali]

I have a pivot table that shows all the teacher sets for a given year and a count of the feeder school.

Set School total
a anytown 2
a somewhere 3
Total 5
b anytown 2
b somewhere 3
Grand Total 10


What I need to be able to do is show the totals for all groups, a grand total and more diificult have the numbers shown as a percentage of the set not the Grand Total.

Thanks for your help

Kevin

 

[GorD]

So what results would you expect from the data above?

 

[Kevali]

I would hope I can get the result to be

Set School total
a anytown 40%
a somewhere 60%
Total 50%
b anytown 40%
b somewhere 60%
Total 50%
Grand Total 100%

 

[GorD]

You may need two pivot tables to show all the results you want.

Book1
	A	B	C	D	E	F	G	H	I	J
15							Set as %age of Row
16	Set	School	Total				Sum of Total	School
17	a	anytown	1				Set	anytown	somewhere	Grand Total
18	a	somewhere	1				a	40.00%	60.00%	100.00%
19	a	anytown	1				b	40.00%	60.00%	100.00%
20	a	somewhere	1				Grand Total	40.00%	60.00%	100.00%
21	a	somewhere	1
22	b	anytown	1
23	b	somewhere	1
24	b	anytown	1
25	b	somewhere	1				Set as %age of Total
26	b	somewhere	1				Sum of Total	School
27							Set	anytown	somewhere	Grand Total
28							a	20.00%	30.00%	50.00%
29							b	20.00%	30.00%	50.00%
30							Grand Total	40.00%	60.00%	100.00%
Sheet1

To change to percentages select one of the data values, right click, field settings then Options, then change the "show data as" box

Hope it helps a bit