Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try: only({<Week={$(vCurrWeek)},Year={$(vCurrYear)}>}aggr(NODISTINCT rank(total sum({<Year={$(vCurrYear)}>}Sales)),Week))
Try: only({<Week={$(vCurrWeek)},Year={$(vCurrYear)}>}aggr(NODISTINCT rank(total sum({<Year={$(vCurrYear)}>}Sales)),Week))
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))