Pivot Table Percentages

[sscornav]

I have the following data and Pivot:

Excel Workbook
	A	B	C	D	E	F
1	Program	Release	Weight	Status	Size
2	P1	R1	35%	On-Time	Jumbo
3	P1	R2	35%	Late	Jumbo
4	P1	R3	30%	In-Process	Jumbo
5	P5	R1	100%	Late	Large
6	P6	R1	100%	In-Process	Small
7	P2	R1	60%	On-Time	Medium
8	P2	R2	40%	Late	Medium
9	P3	R1	100%	In-Process	Large
10	P4	R1	10%	On-Time	Small
11	P4	R2	70%	Late	Small
12	P4	R3	20%	Process	Small
13
14	Sum of Weight	Status
15	Size	In-Process	Late	On-Time	Process	Grand Total
16	Jumbo	0.3	0.35	0.35		1
17	Large	1				1
18	Medium		0.4	0.6		1
19	Small		0.7	0.1	0.2	1
20	Grand Total	1.3	1.45	1.05	0.2	4
Sheet1

Is there a way to get the values in the cells to show up as percentages of the total?
So the value in the Jumbo/In-Process would be (.3/4 = 7.5%)

Thanks!

 

[danzon]

You will need to use "calculated fields" in your pivot table

http://www.contextures.com/excel-pivot-table-calculated-field.html