Need a column to show 1 as %age of the other - simple ?
 

I know this should be simple, so why is it causing me so much grief ??

Data....
Type Complete
Kitchen 1
Kitchen 0
Kitchen 1
Kitchen 1
Kitchen 0
Kitchen 1
Kitchen 1
Kitchen 0
Kitchen 1
Bathroom 1
Bathroom 0
Bathroom 1
Bathroom 1
Bathroom 1
Bathroom 0
Bathroom 1
Bathroom 1
Door 0
Door 1
Door 1
Door 1
Door 0
Door 1
Door 0

Simple ! The 0 & 1 indicate not complete / complete.

My pivot table shows...
Type Count of type Sum of Complete
Bathroom 8 6
Door 7 4
Kitchen 9 6

What I need is to have a third column showing the number of complete
as a %age of the row.
So.... 75%, 57%, 66%.

HELP !!!!

Need a column to show 1 as %age of the other - simple ?
 

I should have added this is Excel 2003/SP3 and this is a Pivot Table
issue.

Need a column to show 1 as %age of the other - simple ?
 

Hi Neil

Drag Type to Row area
Drag Complete to Column Area
Drag Type to Data area as Count
Drag Type to row Area again as CountOptionsShow data as % of Row
Title 0 as Incomplete, 1 as Complete

--
Regards
Roger Govier

wrote in message
...
I know this should be simple, so why is it causing me so much grief ??

Data....
Type Complete
Kitchen 1
Kitchen 0
Kitchen 1
Kitchen 1
Kitchen 0
Kitchen 1
Kitchen 1
Kitchen 0
Kitchen 1
Bathroom 1
Bathroom 0
Bathroom 1
Bathroom 1
Bathroom 1
Bathroom 0
Bathroom 1
Bathroom 1
Door 0
Door 1
Door 1
Door 1
Door 0
Door 1
Door 0

Simple ! The 0 & 1 indicate not complete / complete.

My pivot table shows...
Type Count of type Sum of Complete
Bathroom 8 6
Door 7 4
Kitchen 9 6

What I need is to have a third column showing the number of complete
as a %age of the row.
So.... 75%, 57%, 66%.

HELP !!!!