Getting Pivot Tables to Displace Columns Populated Only with 0's

[jras414]

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

 

[Ken]

In Excel 2003, right click on the field heading on the pivot table;
then click field settings. In the lower left corner of the form you
shoud see a check box to "show items with no data". If you check that
box I think you will get what you want. I am sure you can do
something similar in Excel 2007 but you never know where they may have
it hidden.

Good luck

Ken
Norfolk, Va