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!