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

    Include only these Dimensions in Set Analysis

    Mike Czerwonky

       

      =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?