Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
More Pivot Table Hullaballoo... text value grouping
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 " 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Grouping | Excel Discussion (Misc queries) | |||
Pivot Table - Grouping | Excel Worksheet Functions | |||
Grouping in Pivot Table | Excel Discussion (Misc queries) | |||
pivot table grouping | Excel Discussion (Misc queries) | |||
Pivot Table Grouping | Excel Programming |