N
neil.sparkle
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 !!!!
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 !!!!