Hot to put conditions in the query.(Very very urgent )
Hi BW Gurus,
Pls give me a solution for this one i have to give it today only the report pls consider this as urgent.
new BW report, following is an explanation of the report requirement what the report would look like.
The logic of the report is to retrieve all chargebacks based on certain Selection Criteria entered by the user.
Selection Criteria are as follows:
Posting Key - this should not be a value entered by the user
There should also be a selection parameter available to the user to specify the report type. The selection list should be as follows:
Each of the above may be viewed as a report variant. This selection parameter basically specifies the number of customers to be displayed, e.g. Top 3 means that the top 3 customers from a chargeback total perspective should be displayed.
The report should display by Customer by Reason Code the value of the Chargeback. A total for Chargebacks should be calculated per reason code, per customer and a total for the report
The report should also provide drill down capability in that the user should be given the ability to drill down by customer by reason code to display all chargeback line items that make up the total for that reason code for that customer.
Thanks in advance.