Sub Total of UOM used

Hi Gurus,

We have a Report req where we need the report layout as below:

Cost Element Value in reporting Currency Qty Unit of measure Vendor Doc no Date

Our first Issue is how to achieve this sequence of fieldsin BI as it has key figs(like quantity) in between and then again characteristics(like Unit of measure).

secondly in our data we have different 'unit of measure' for one cost center and thus we need sumary of number of each 'unit of measure' for one particular Cost center and then consolidated sumary for all the cost center.

Could anyone guide me to achieve this req

Thanks

Edited by: Deepika Jain on Oct 15, 2008 3:25 PM