Week Rank

[Anonymous]

Trying to show the Rank of current week based on Sum of Sales and Region. Attached is a sample.

I need to show only current week data but also it's Rank with respect to previous weeks of the year.

Thank you.

[Gysbert_Wassenaar · Accepted solution]

Try: only({<Week={$(vCurrWeek)},Year={$(vCurrYear)}>}aggr(NODISTINCT rank(total sum({<Year={$(vCurrYear)}>}Sales)),Week))

[Anonymous]

Thank you Gysbert!

I just had to add Region and take out Total:

only({<Week={$(vCurrWeek)},Year={$(vCurrYear)}>}aggr(NODISTINCT rank(sum({<Year={$(vCurrYear)}>}Sales)), Region, Week))