Hi BW gurus,
I have a scenario in reporting. At a single point of time i have data either for Amount(USD) or Sales Volume(Litre) in the database. In Bex reporting, I need to display only one column by adding Amount and Sales Volume using NODIM but the trick is I have to show the unit information also. How to achieve this. Please see below the example.
Amount SalesVolume New Column
1000USD 0 1000USD
0 100Litre 100Litre
For this, I can add Amount and Sales Volume using NODIM but finally I need to show the unit also. Please guide me asap.
Regards,
Kesavan.