Skip to Content
0

Top 10 Revenue based on Month

Dec 20, 2017 at 05:47 PM

61

avatar image
Former Member

Hi Fellows,

I am trying to get Top 10 Customer based on revenue Group by Month, Customer name so that for every month I get top 10 customers. Not sure how I can do that in WebI 4.2.

Any suggestions?

Thank you for your help.

10 |10000 characters needed characters left characters exceeded
Former Member

Sorry for that Tammy. I used the Rank functionality to but it is not giving me the right results. If I do it for the entire dataset then I get the correct values but I need it by month by customer name. So each month should have top 10 customers based on total revenue and I will give month as input control so that if more than one month is selected, aggregation happens at the month level by customer.

0
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Erdem Pekcan Dec 21, 2017 at 01:25 PM
0

Hi,

You can use rank function and the filter the variable with <=10.

Rank(measure;[ranking_dims][;Top|Bottom][;(reset_dims)])
Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 21, 2017 at 02:50 PM
0

Hi Erdem,

Thank you so much for your response! I used the exact same formula to get the results and I am getting the results but when I select two months (say Jan and Feb), the data is not aggregating to only give me Top 10 based on 2 months. It is showing me Top 10 for Jan and Top 10 for Feb where few customers are repeating twice.

Share
10 |10000 characters needed characters left characters exceeded
Graziano Oliveira de Morais Dec 22, 2017 at 12:18 PM
0

Hi

Try this:

=Rank([Sales revenue];([Month];[SKU desc]);Top;([Month]))


rank.png (27.8 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

in rank function replace sku_desk and month with your dimension objects

0