Top 15 rank v's remaining entities
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?
Answers
-
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
1 -
Thanks for your comments Ray. Will try the workaround.
0
