Skip to Content
0

How to get Top 10 Customers based on Net Sales using variable?

Dec 20, 2017 at 04:56 AM

56

avatar image

Hi Experts,

We are working on Webi report based on Bex query.

Right now we have more than 2.5k customers in the database. When I take customer dimension in input control, it takes a lot of time to load input controls. That is why I want to show only top 10 customers in the input control.

I want to create Dimension variable which will give me list of top 10 customers based on Net Sales.

I tried using the Rank function but when I drag that variable to report its showing #CONTEXT and #MULTIVALUE error.

How to create this variable?

Thanks

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Koen Hesters Dec 20, 2017 at 10:17 AM
0

Hi,

  • sort your table with the measure descending
  • add variable rowcount

  =RunningCount(1)
  • filter table on rowcount less than or equal 10
Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Koen,

Thanks for the reply.

But I don't want to show top 10 customers in Table. I want to use them in the Input control.

Right now we have more than 2.5k customers in the database but I want to show only top 10 in the input control.

Regards

0

You could work with element linking from that table on (best to create the top 10 via ranking than also, no special variable needed)

something like this

1
Graziano Oliveira de Morais Dec 20, 2017 at 12:03 PM
0

You can use the ranking to do this, follow a link that explains how to use:

http://www.bidw.org/business-objects/web-intelligence/ranking-data-in-web-intelligence-report/

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Graziano Oliveira de Morais,

Thanks for the reply.

But I don't want to show top 10 customers in Table. I want to use them in the Input control.

Right now we have more than 2.5k customers in the database but I want to show only top 10 in the input control.

Regards

0

Pan Kaj,

Inside the webi, I can not see a way for you to do this.

If you use the function that rank or runningcount for example it will only display the value 1.

Maybe one output is to create a calculated field in your bex query so that it can be used in the input control

0