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

SAP Knowledge Base Article - Public

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

Symptom

  • How to display the rest from a ranking fonction?

Cause

This feature does not exist

Resolution

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

Keywords

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

Product

SAP BusinessObjects Xcelsius Enterprise 2008