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

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.

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

Hi Jerry

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

--
Regards
Roger Govier

Jerry G wrote:
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.