You can calculate the weekly revenue growth week over week and then use rank function on the growth.
Rank(weekly revenue growth week over week, 'desc|asc')
If you want top revenue dimensions then you have to order the rank in desc order and pick top 5 or 10. or if you want to low revenue dimensions then you need to calculate the rank in asc order and pick top 5 or 10.
Thanks for the response, but I think there's confusion as to how I want spend ranked.
Basically in 2 different sheets, I'd like for the user to be able to select any given week in a month (week 1, 2, 3, etc), and have populate in descending order, the buyers (spenders) that had the sharpest decrease % in revenue and next to that window show which buyers had the sharpest increase % in revenue in a new window (2 sheets).
I'd like for this to auto rank the % according to the given week in the year the user selects, and it show the percentage increase/decrease compared to the previous week.
You can apply some rule like complicated still and other there are most important rule to you .