Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 282 Oracle Analytics and AI News
- 59 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 108 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Top n and rest/others aggregated
Jorge Olmeda
Rank 5 - Community Champion
Hello,
In many cases, I face the need of having to create viz where I need to rank Top n customers/countries/products, etc. and then list the rest beyond the Top aggregated together as "Rest" or "Others". I'm always struggling in using complex formulas to achieve this and it would be fantastic if we had an option to show Top n customers/countries/products, etc. and then OAS to be able to aggregate together "Other"/"Rest" based on the selected dimensions and facts.
Please, see the next chart for an example:
Thanks!
Cheers,
Jorge
5
Comments
-
Excellent idea. It is excellent one for present.
0

