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

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


On Sep 30, 12:27*pm, jras414
wrote:
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!!