7 Replies Latest reply on May 17, 2018 5:30 PM by Peter Fakan

# Subsets from a set

hi

Is it possible to group dimensions as subsets of a set?

so for example i have this set which i would like to put into groups rather than it being one long list.

Is this possible?

Please excuse the shoddy cover up!

• ###### 1. Re: Subsets from a set

Hi Ben

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)

Jim

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.

• ###### 2. Re: Subsets from a set

Hi,

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.

Regards,

Rahul

• ###### 3. Re: Subsets from a set

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?

• ###### 4. Re: Subsets from a set

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.

• ###### 5. Re: Subsets from a set

So for example in the US you would have states as the main set then cities as the subsets?

• ###### 6. Re: Subsets from a set

Hi Ben,

Not sure about the actual requirements but trying as below :

Step 1

Created 2 Groups

1) West ---->California

2) North East ---> New York

Step 2

Copy below

IF [State]= 'California' then [City]='San Jose' or [City]='Fresno'

END OR

IF [State]='New York' then [City]='Yonkers' END

Step 3

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.

Thanks,

Ritesh

• ###### 7. Re: Subsets from a set

Hi Ben,

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.

HTH

Peter