More Pivot Table Hullaballoo... text value grouping

[aspoede]

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!

 

[Guest]

You can group non-numeric data in a Piovt table. The Pop-up that says the
selection can not be grouped appears if only one item is selected. First,
select all the members of a group ( everything outside the US ). Then Right
Click > choose Group Outline > choose Group. Excel inserts a new column with
GROUP1 etc. Then change the label GROUP1 by typing over it.

To do the same in code select the range of values you want to group
Range("B34:B40").Select
Selection.Group

ActiveSheet.PivotTables("PivotTable2").PivotFields(1).PivotItems("Group4") _
.Caption = "test group"

Regards,
Mike