Thanks for your time. I have the following scenario and got stuck with the expression.
1). I use a text box to show the rank of an analyst based on the sum of a metric...
How it works is...
1).We select at least 1 analyst from the list box - for the selected analyst i get the sum and rank then apply the selected analyst EmplloyeeID= using a variable
2)There are other filters like year, quarter, month, LOB, Etc... when 1 value is selected (it is for 1 value selected in the listbox only ) the expression should consider the value selected in the list box say for ex: Year and the SUM and rank should be for the selected analyst and for the selected year, etc for quarter, month, LOB
i cannot get this expression to work...could someone please help - I have been using 1 in the set modifier to get all the records because i have to get the sum and rank for the analyst based on the dataset of the total analysts
then when selecting the year i need to filter for year and so on for the other filters.. if i take out the 1 from set modifier
the analyst rank is wrong as it will always show 1