Skip to Content
0
Nov 16, 2011 at 12:30 PM

Adding two keyfigures of different unit

43 Views

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.