Prev: How to undo overwrites?
Next: Key Board shortcut to Status bar
From: Roger Govier on 19 Apr 2010 04:18
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.
 | 
Pages: 1
Prev: How to undo overwrites?
Next: Key Board shortcut to Status bar