| 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 !!!! |
| 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 | |||
Threaded Mode
