not easy to see from the image but you can group dimensions as shown below
then when the box opens create your groups
you will have a new dimension
with the old dimension name and (grouped)
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
You can group values of dimension by right clicking on dimension and select create group. then group the values together as you wish. is this you wanted.
Thanks for getting back to me
I want to create one over riding group and then mini groups in that group. Does that make sense?
Sorry, i didn't get u exactly. Do you mean something like..lets i have list of 20 cities from US and first group it into four different regions then in the filter i want initially only four regions to show, but when i click on particular region, it should show the list of cities belonging to that region for filter application.
So for example in the US you would have states as the main set then cities as the subsets?
Not sure about the actual requirements but trying as below :
Created 2 Groups
1) West ---->California
2) North East ---> New York
IF [State]= 'California' then [City]='San Jose' or [City]='Fresno'
IF [State]='New York' then [City]='Yonkers' END
Drag above Calculation to filter and set as TRUE and rest of the fields to Rows shelve
So I have a Group within group here.
What you are doing sounds like hierarchy's, but you mentioned groups in your OP.
Just r/click the pill inside your dimensions area, and select from the Hierarchy menu. Subgroups would be added as subordinates to the hierarchy but you can also pick up the pill and drag it into the hierarchy as well.