how to rank dynamically in spotfire when the dropdown is used to filter the data

[meltem nezirova]

I have a line chart that uses dropdown to filter the data. I always want to show the top 10 values whatever the dropdown is. I don't want to make the top 10 values for all the data. I tried Intersect expression for the calculated column to rank the databut it didn't work I expected. Is there any other way to do this

 

DenseRank(First([YValue]) over (Intersect([A],All(),All([C]))),"desc")

[Gaia Paolini]

can you elaborate on the desired scenario I don't understand how the drop-down (document property) is meant to filter and what column the top 10 values are meant to be for.