Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting Pivot Tables to Displace Columns Populated Only with 0's
Hi All,
I want to generate a pivot table that will look as follows: Group 1 Group 2 Group 3 Bob Susan Bob Susan Bob Susan Item 1 1 0 0 3 7 1 Item 2 3 1 0 2 9 0 : 0 7 0 5 4 0 : : : : : : : Even if there are no assocated values for a particular sub column, such as Bob in Group 2, I still want the pivot table to display a column for Bob under Group 2, and then just populate it with zeros. Currently, I just get a results like this: Group 1 Group 2 Group 3 Bob Susan Susan Bob Susan Item 1 1 0 3 7 1 Item 2 3 1 2 9 0 : 0 7 5 4 0 : : : : : : Note how Bob no longer shows up under Group 2, since his column technically has no associated values. If anyone could provide some guidance on this topic, I would really appreciate it. Please feel free to ask for clarification if necessary. Thanks in advanced!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables: Subtotal only certain columns? | Excel Discussion (Misc queries) | |||
Pivot tables - new columns | Excel Worksheet Functions | |||
Adding columns in pivot tables | Excel Discussion (Misc queries) | |||
pivot tables - add columns | Excel Worksheet Functions | |||
Pivot Tables - # of Columns | Excel Discussion (Misc queries) |