cancel
Showing results for 
Search instead for 
Did you mean: 

top 10 based on two conditions

Former Member
0 Kudos

Hello BW Experts,

Wondering if this is possible in Bex.

-- by default show the top 10 customer based on gross sales

-- then give a navigational option in the context menu to show the top 10 customers by net sales.

can this be achieved in bw using conditions.

Any suggetions is greatly appreciated.

Thanks,

BWer

Accepted Solutions (1)

Accepted Solutions (1)

former_member188975
Active Contributor
0 Kudos

Hi BWer,

It is possible to do this using conditions. Start creating a condition in the query and use the Top N condition. Create 2 of these: One for each key figure. Then in the report you can activate and deactivate them to see results are desired.

Hope this helps...

Answers (0)