Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello - I am trying to write a set analysis expression that would show a sum of the top 10 recruiters based on recruiter's number of new applications. I want that number to stay constant no matter what Recruiter SID filter is applied. I am using the formula below but because 'Recruiter SID=' isn't applied to the rank portion of the expression it is not working the way I would like it to. Any assistance would be greatly appreciated!
=sum({<[Recruiter Full Name]={"=(Rank(SUM([New Apps]))<=10)"},[EVENT ID]={'OPN','SSH'},[Month Number]={'=$(#vSelectedMonthNumber)'},[Event Month]=,[Recruiter SID]= >}[New Apps])
So, then add it... may be like this
=Sum({<[Recruiter Full Name] = {"=Rank(Sum({<[Recruiter SID]>} [New Apps]) <= 10)"}, [EVENT ID] = {'OPN','SSH'}, [Month Number] = {'=$(#vSelectedMonthNumber)'}, [Event Month], [Recruiter SID]>}[New Apps])