Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a Rank table that ranks sales territories based on sales. The below expression works great if no selections are made.
Aggr(
Rank(
$(QTD_Sales),
),
[Territory Rep])
However, if a selection is made, say a specific rep is selected, their rank becomes 1. For example. TM Boston is 17 overall with no selections made.
but if I select TM Boston, then their rank changes to 1
I need it to stay 17.
I need the ranking to consider all of the reps regardless of which rep is selected so we can look at specific rep information and their overall rank.
Thanks!
How is $(QTD_Sales) defined? You need to ignore selection in Territory field for the variable
How is $(QTD_Sales) defined? You need to ignore selection in Territory field for the variable
May be in QTD_Sales variable inside Sum function you need to use set expression as {<Territory Rep=>} or any other field for which you want to disregard selections