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