Thread: 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!

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

"aspoede@gmail.com" wrote:

> 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!
>
>