Top 10 Rank

[KPage]

Hi,

I am trying to only include the Top 10 in rank. Below is my expression. This shows the rankings of the items by sales. I only want the top 10 ranked as pictured below

If(

sum({<[Week Ending]={'$(=date(Max([Week Ending])-7,'MM/DD/YYYY'))'}>}[Retail Sales]) + 

    Sum({<[Week Ending]={'$(=Max([Week Ending]))'}>}[Retail Sales]) <> 0,

    Rank(TOTAL Sum({<[Week Ending]={'$(=Max([Week Ending]))'},Manufacturer=,Brand=>}[Retail Sales]),1,1) 

)

[ajaykakkar93]

Hi,
Can you try 
if(Rank(Sum(.....EXPRESSION....) < 11, ....EXPRESSION... )