Pivot Table Groupings Fail if 1of the items isn't in the next data

[Jerry G]

I am Grouping items together in a Pivot Table and everything works fine until
I use the next months data. For example, I have different types of earning
codes and I am grouping as follows.

Codes
1, 3 & 5 = Group A
2, 4 = Group B
6 = Group C

If in the next pay period, I do not have any Code 4 Earnings, Group B looses
the Group B name, and becomes '2'. It changes every pay period and I rarely
have all codes in the same pay period.

 

[Roger Govier]

Hi Jerry

Double click on the field Code, and select Show Items with no data.