| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 !!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 !!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| This seems like it should be so simple! (PivotTable "Show values a | Excel Discussion (Misc queries) | |||
| Show random labels in simple line chart | Charts and Charting in Excel | |||
| one column of cells show ####. Values show when I open it. Help | Excel Discussion (Misc queries) | |||
| Simple 3D Column | Charts and Charting in Excel | |||
| How do I show a percentage in Excel? Or do a simple subtraction? | New Users to Excel | |||
Hybrid Mode
