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)
)
