Skip to Content
0
Former Member
Aug 20, 2015 at 01:07 PM

Top N / Bottom N and the rest as additional field

1168 Views

Hi all,

we have the following requirement which I am not able to fullfil:

Designing a query which shows not only a Top N or Bottom N selection but also the rest in an additional line at the end.

This query should be the basis for a design studio application.

This is what we want:

TOP 3 Customer

Customer Sales Percentage Smith 45000 30% Jones 30000 20% Brown 15000 10% REST 60000 40% TOTAL 150000 100%

This is what we get:

TOP 3 Customer

Customer Sales Percentage Smith 45000 30% Jones 30000 20% Brown 15000 10% TOTAL 150000 100%

We created a query with two variables: one for top n and another for bottom n.

These variables have to be filled when executing the query.

So the user can select a free quantity of top or bottom n.

(We do not know the total quantity of all members)

Within the table the user may calculate the percentage of the rest by himself.

For this reason we added the "Percentage" column to show the relation of the top n to the total.

But we want to see the distribution also within a pie chart.

And there it is totally senseless to display only the top three and their distribution without a rest.

It is mandatory to have a rest when using a pie chart.

Is there no way how we can combine some filter or whatever in query designer to fulfil this requirement?

I googled for a while and found nothing, but I cannot image that with SAP BW it is not possible to create a Top N list with an additional item "rest".

In my opinion this is common need.

There is a need for a new variable in BEx Query Designer "TOP N + REST" or something like that...

Hopefully someone has an idea or hint how to solve this problem.

Regards

Steffen Bruckner

Attachments

2.jpg (29.5 kB)
1.jpg (18.2 kB)