cancel
Showing results for 
Search instead for 
Did you mean: 

how to display only top 5 customers and their revenues

Former Member
0 Kudos

Hi,

can any body suggest me how to get top 5 customers sales revenue info into bex.

thanks in adv..

regards

milinda

Accepted Solutions (1)

Accepted Solutions (1)

GFV
Active Contributor
0 Kudos

Hi Milinda,

use Conditions (see on top of the BEx Tool Bar of Query Designer). Define a Condition TOP n (n = 5 or variable value) on revenues key figure.For more infos about how to see the following link:

http://help.sap.com/saphelp_sem40bw/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm

Hope it helps

GFV

Answers (0)