Top 15 rank v's remaining entities

Louise Just

I need to create a report that shows the top 15 entities with total and share.  This is easy and I can do.  The part I am having trouble with is how to display the remaining entities that are not top 15 and what share they make up.  I don't need to see the detail of the remaining entities, rather just want to see them as a total.  Attached is example of what I am trying to achieve.  Is this possible?

Previous Member

Hi Louise Just,

this is a popular topic and there is no buildin functionality to allow it. Here is an idea on that topic to vote on: “OTHERS” AUTOMATICALLY GROUPED WHEN USING KEEP TOP FUNCTION 

 

If you're looking for a workaround, in the following thread there are two possibilities to do so:

How to create view with Top X values + 'Others' grouped in one value 

 

BR, Ray