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

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

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