I have a straight table with top employees with biggest values. A user can pick a number of months in the filter to see top employees.
What i need to achieve is: if the date of dismissal of employee is greater than max month picked in the filter than he will be in this list, if his date of dismissal in earlier than max month picked than this employee won't be included in the list.
I used the calculated dimension, but it's not working correctly :
=aggr(IF(Rank(IF(isNull(Dismissed) or num(Month(Dismissed))>=num(Max(Month(Month_Date))),Sum(Bench_Data)/$(vNoOfMonths)))<=10,Emp_name),Emp_name)
