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?