3 Replies Latest reply on Feb 1, 2016 1:55 AM by Towab Muhammad Yusuf

# WoW rank according to revenue percentage growth and/or drop

Anyone know how I would go about creating a calculated field that can rank buyers by most revenue growth week over week (WoW).  Conversely, a formula that shows which buyers had sharpest decrease in spend WoW.

Essentially, i'd like to be able to filter by week and quickly identify all of the buyers sorted or ranked by who had the highest percentage in revenue growth or drop in spend

Dimensions would be:

- Week Group (I made this calculated field using "Day")

Measures would be:

- Estimated Revenue

So far, i've tried using this suggestion, but ran into an issue with my date filter not populating the dates correctly

Any assistance would be greatly appreciated!

• ###### 1. Re: WoW rank according to revenue percentage growth and/or drop

Hi Olivia,

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.

Regards,

Venkat

• ###### 2. Re: WoW rank according to revenue percentage growth and/or drop

Hey Venkat,

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.

• ###### 3. Re: WoW rank according to revenue percentage growth and/or drop

You can apply some rule like complicated still and other there are most important rule to you .