Oracle Analytics Cloud and Server Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Top n and rest/others aggregated

Under Review
11
Views
1
Comments

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
5 votes

Under Review · Last Updated

Under Review - Avinash K

Comments