10 Replies Latest reply: Jun 2, 2010 4:54 PM by Heiko Hafenmaier RSS

Display Units in separate column next to key figure

Dave Dusza
Currently Being Moderated

Hello All,


Could someone please explain step by step how to display the key figure results in one column and the mapped unit in the next column using bex analyzer 3.5.   An example would be:




Order# 1  Cost Element1       100Lbs      $100

Order#2   Cost Element2            5Pcs        $50


Should be:


Order#1  Cost Element1        100   Lbs        100    USD

Order#2  Cost Element2          5     PCs          50    USD


I should mention that I've tried displaying the characteritic for units in both the rows and columns with no success  when I displayed it in rows I received the following results:



Order#1  Cost Element1     Lbs          100           

Order#1  Cost Element1     USD                                 100

Order#2  Cost Element2     Pcs                    5

Order#2  Cost Element 2    USD                                    50


In summary I would like to display the unit key whichever it may be for the key figure for quantity in one column.  Any help would be appreciated.