Dear Experts,
We'd a certain Requirement - Where a characteristic is to be derived based on Key figures & Character
Scenario is as like below.
In the below mentioned cross tab "Character to be Derived " column to be derived based on below mentioned condition
a. if Reaso = # & Order Qty = Invoice qty then Character to be derived as 'Y' else #
OrderNo OrderItem Reaso Charactertobederived OrderQty InvoiceQty
O1 10 X X 10 0
O1 20 # # 10 5
O2 10 # Y 10 10
Thanks
-Ram