6 Replies Latest reply: Jan 8, 2016 11:28 AM by Sébastien Fatoux

# Include only these Dimensions in Set Analysis

=count(distinct{<[Enrollment Counter Date]={'>\$(vPriorMonth12Max)'},[Eligibility Benefit Type]={'Medical'},[Claim Paid Period]=,[Enrollment Period]=>}[Member Months Counter]),

I have this formula in my application and I want to only include current selections from two of my possible dimensions to determine my chart output.  I have 100 dimensions in my app and want to ignore current selections from any others.

I know how to exclude specific dimensions in Set Analysis by using      [Claim Paid Period]=   It obviously is not practical to add all of them in this matter.

How do I specify in Set Analysis to only include selections from my two desired dimensions  [Name] and [Group Number] and ignore the rest?

• ###### Re: Include only these Dimensions in Set Analysis

Try something like

Count( {1<[Name] = \$::Name, [Group Number] = \$::[Group Number] >} FieldName)

• ###### Re: Include only these Dimensions in Set Analysis

swuehl is right.

Just to explain her solution :

Count( {1<[Name] = \$::Name, [Group Number] = \$::[Group Number] >} FieldName)

1 To specify that we use the entire set of data without take care of the user selection

[Name] = \$::Name To specify that we will assign to the field "[Name]" of the Set Analysis values of the field "Name" defined by the user selection (\$)

• ###### Re: Include only these Dimensions in Set Analysis

I am testing this right now.  As you can see, I have a variable filter and a static filter in my example above.  Can this solution work in conjunction with those?

• ###### Re: Include only these Dimensions in Set Analysis

Yes, without problem

• ###### Re: Include only these Dimensions in Set Analysis

Thanks to both of you!   I was able to make it work!  I looked pretty extensively through the forum and did not find anything like this.  This looks like a good topic for the resource library.  One of the two of you should create a document to post on this.