Current Position:Home > Top 10 based on two conditions

Top 10 based on two conditions

Update:11-30Source: network consolidation
Advertisement
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

The Best Answer

Advertisement
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...
  • Top 10 based on two conditions Update:11-30

    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 con

  • Inserting new columns based on the condition! Update:11-30

    Hi guys, I have a very simple query like the following…  SELECT table2.column_code2, table2.column_description2,              table2.column_code1,              table1.column_description1 FROM database_001.table2 table1 LFET OUTER JOIN database_001.ta

  • Need to calculate Document amount based on below conditions Update:11-30

    Hi Everybody Here I need to calculate Document amount based on below conditions in the report iam having all the fields. 1)     If the Net Due Date is one or up to tens days less than the document date on any open AP item 2)     If the Net Due Date i

  • Can we take standard report for all sales orders based on the condition typ Update:10-11

    Hi all, Based on the condition type, we need to take a report for sales orders on the particular date. Thanks and Regards.....VMHello again. Searching for a solution, I found a Logical Database for sales orders, that have all the information that you

  • Report  S_ALR_87012167 top list based on amount of overdue items Update:10-11

    Hello, We are using report S_ALR_87012167 (Accounts Receivable Information System). In this report, it is possible to customize how many customers should be involved in the TOP list, the other customers are summarized in REST. This works fine. Howeve

  • VT02N - do PGI and Invoice for certain deliveries either based on certain conditions Update:10-11

    Hi Friends , We are using VT04 for creating shipments . While shipment completion stage in VT02N   an activity profile has been maintained  which does both the Goods issue and Invoice. We have a business requirement , PGI and Invoice should be create

  • How to create a column based on a condition ? Update:10-11

    Hi all, I am trying to create a stored procedure that will return ID,Name and a column of type bit called  called checked based on a condition  please review my code and tell me what is wrong with it  ALTER PROCEDURE [dbo].[SelectStoresNames] AS BEGI

  • How to secure access of Report based on a condition Update:10-11

    Hello Experts, My project requirement is to secure BW Reports based on a condition. For e.g a user should be authorized to access the Report if: 1. He is the WBS Manager of the selected WBS Element OR 2. If he is authorized to access the Profit cente

  • Column value coloring Based on the condition in ssrs 2008 Update:10-11

    Hi, I need to change color formating based on below conditions Red if <=28 days or > 65 days        Green if >28 and <=60 days        Yellow if > 60 days and <=65 days <=0 No color I tried with below IIF condition it's not working. =i

  • Dropdown editable in a table based on a condition Update:10-11

    Hi, I would like to know how to solve these problems. 1. I have a cell (of the type dropdown by key) in a table, which is editable or not, depending on a condition ? Is this is possible? Please let me know if there is a sample code 2. So basically I