Skip to Content

Sorting a Ranked Table with "Others"

Sep 29, 2017 at 02:17 PM


avatar image
Former Member


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.


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

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

Hi Bram,

Have you tried creating a Rank dimension? something like:


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,


10 |10000 characters needed characters left characters exceeded