More Pivot Table Hullaballoo... text value grouping
I understand that I can only group numeric data, but I was wondering if
anyone has an ingenious way of grouping text values. I have values
with country of origin listed. IE:
United States,
UK
Spain
Germany
Other
Basically what I want to do is group everything outside the U.S. into a
group called "International" so I can pivot between United States and
International.
Any ideas?
Thanks!
|