Skip to Content
avatar image
Former Member

Top 10 Revenue based on Month

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.

Add comment
10|10000 characters needed 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.

  • Get RSS Feed

3 Answers

  • Dec 21, 2017 at 01:25 PM

    Hi,

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

    Rank(measure;[ranking_dims][;Top|Bottom][;(reset_dims)])
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 21, 2017 at 02:50 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 22, 2017 at 12:18 PM

    Hi

    Try this:

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

    Add comment
    10|10000 characters needed characters exceeded