Thread: Pivot Table Groupings Fail if 1of the items isn't in the next data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_8_] Roger Govier[_8_] is offline
external usenet poster
  
Posts: 376
Default 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.
Reply With QuoteReply With Quote