Pivot Table Help

[RR Guy]

I created a pivot table showing a individual, and hours by labor code. So for instance:

Person Labor Type Hours
Abby 01 5
Abby 02 10
Ben 01 6
Ben 04 12

I want a column to show the % of the individual's time for each labor code. SO per the example above I woud have a column showing:

Abby 01 5 33%
Abby 02 10 67%

How can I do this?

 

[Weaver]

What version of excel are you using?

In 2007, when you format the values, go to value field settings. There you'll see a tab 'show values as', choose % row from this.

Excel Workbook
	F	G	H	I	J	K	L
4
5		Sum of hours	Column Labels
6		Row Labels	01	02	04	Grand Total
7		Abby	45.45%	100.00%	0.00%	45.45%
8		Ben	54.55%	0.00%	100.00%	54.55%
9		Grand Total	100.00%	100.00%	100.00%	100.00%
10
Sheet2

Excel 2007

You may have to format the table as above - I couldn't get it to work your way. But then I'm no expert with 2007 pivots