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?