Hi - I am new at using PowerPivot and have a question in regards to creating groups.
Here is my issue. I have 20 different regions in my field "sold to". However, I am constantly being asked to group certain regions together. For example, I would want to combine all North American regions (total of 9 between west, east, north east, etc.)and call them North America and the Asia regions and call them Asia. So would I create a measure to do this or would I create a linked table and a relationship? Any help would be appreciated. Thanks.
Here is my issue. I have 20 different regions in my field "sold to". However, I am constantly being asked to group certain regions together. For example, I would want to combine all North American regions (total of 9 between west, east, north east, etc.)and call them North America and the Asia regions and call them Asia. So would I create a measure to do this or would I create a linked table and a relationship? Any help would be appreciated. Thanks.
and I am using Excel 2010.