1589970 - Display rest of the result of a TOP / BOTTOM Rank in charts

• How to display the rest from a ranking fonction?

This feature does not exist

Solution:

There is no solution for this issue as the feature to display rest doesn't exist. Please check in ideas place if a request for such feature exist and adding your vote. https://ideas.sap.com/community/products_and_solutions

Workaround:

1. Create a Report based on e-fashion with objects 'State' and 'Sales Revenue'
2. Create a variable called 'Ranking' and use the following formula
   =Rank([Sales revenue];[State];Top) ForEach([State])
3. Create another variable "Ranked State" and use the following formula
   =If(([Ranking]>3)ForEach ([State]);"Other";[State])
4. Add a new table
5. Insert objects [Ranked Sate] and [Sales Revenue] 
6. Turn the table to chart

rank, rest, chart, display, rang, affichage, reste , KBA , BI-RA-WBI , Web Intelligence , Product Enhancement