I got stucked with calculated dimension in straight table.
First, let me explain the main idea of this table. This table shows top 10 employees with biggest average value named Bench_data.
I created a calculated dimension: =aggr(IF(Rank(IF(Month_name>=(vCurMonth),Sum(Bench_Data*Forecast),Sum(Bench_Data)))<=10 ,Emp_name),Emp_name)
As you see I have a condition of calculation depending on the period.
I also have an expression like :IF(Month_name>=(vCurMonth),AVG(Bench_Data*Forecast),AVG(Bench_Data))
My management wants to see the average of values for a distinct period and they pick several months in the filter.
What I want now is to add the condition, if the dismissed date of employee is > than the max month picked in the filter, this employee won't be shown in the table.
