G
Guest
Question re: Excel pivot tables...
I have a pivot table where we grouped customer names alphabetically (all A's
together, etc) But this grouping only works for customers already in the
pivot table when we did the grouping. If a new customer is added to the
underlying data, the pivot table leaves them as a separate item in the table.
Is there a way to define a group using wildcards, so that the first group is
for customers named "A*", etc?
Thanks
RonB
I have a pivot table where we grouped customer names alphabetically (all A's
together, etc) But this grouping only works for customers already in the
pivot table when we did the grouping. If a new customer is added to the
underlying data, the pivot table leaves them as a separate item in the table.
Is there a way to define a group using wildcards, so that the first group is
for customers named "A*", etc?
Thanks
RonB