Need Rank to always Rank on all Data regardless of selections

[Anonymous]

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!

[sunny_talwar · Accepted solution]

How is $(QTD_Sales) defined? You need to ignore selection in Territory field for the variable

[Digvijay_Singh]

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