Skip to Content
avatar image
Former Member

Sorting a Ranked Table with "Others"

Hi

Im creating a top 10 of most common contact reasons for our company in WEBI.

I have made a report in which it shows ranked contractreasons so i only show the top 10 and add the rest to "Others" and the sum of how many contacts there where for that reason.

I want to sort the table based on the rank and put the categorie others on the bottom. But i cant seem to get it so any help here would be very appriciated.

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 29, 2017 at 04:02 PM

    Hi Bram,

    Have you tried creating a Rank dimension? something like:

    =Rank([Measure];[contractreasons];Top)

    Afterwards you can filter the chart\table on the [Rank] variable (<=10) and sort by the [Rank] also.

    -------------------

    If that didn't work, please share more information, like current behavior. Screenshots would make it easier also.

    Best Regards,

    Or.

    Add comment
    10|10000 characters needed characters exceeded