Pivot Table Filter Question

[sunrise06]

I have a pivot table of Names in the ROWS section and Groups in the COLUMNS section with the VALUES counting the number of Names. In my groups there are 3 categories, A, B, or C. Let assume I have 10 names but only 8 of them are in Group A. If I filter for just Group A, it shows me the 8 names.

MY QUESTION - Is there a way to keep all 10 names displayed so I can see who is and who is not a member of Group A?

Yes, I can NOT apply a filter and see all of the names in each of the groups but would prefer to be able to see, in this example, just Group A with all of the name whether in that Group or not.

THANKS!

 

[RoryA]

Right-click the row field Names, and choose Field Settings, then on the Layout and Print tab, check the 'Show items with no data' option.

 

[sunrise06]

Thank you for the prompt response. That would work great except I did not mention that that I also have a filter in the FILTERS section and your suggestion appears to now ignore that filter. For that filter lets assume it is the Owner's Name. Rather than listing only those under that owner, it is no including everyone. Am I missing something?

 

[RoryA]

No, it's an all or nothing option.

 

[sunrise06]

OK, thanks! That's too bad.