0 Replies Latest reply: Jul 26, 2017 11:48 AM by Mark Ritter RSS

    Ignore calculated Dimension in Set Analysis

    Mark Ritter

      I have a Dimension that is based on an expression to limit the values that are displayed (2012-2017):


      =if(num([HireDate.autoCalendar.Year])> $(V5YearAgo), [HireDate.autoCalendar.Year])


      In my set analysis expression I want to ignore the above choice when calculating 

      I tried [HireDate.autoCalendar.Year]= and that doesn't work.

      Count( {$<StatusText={'Active'},[HireDate.autoCalendar.Year]=>} Distinct  EmployeeID)

      Is there a way to have the set analysis ignore the calculated dimension?