BEx : Merge the Result of two Rows

38 Views

Hi,

I have an issue with BEx Total Value. Currently, For Each Purchase Order, I am having multiple Items. And i need to get the PO Cost by adding up the individual values of Each Item and the Reult should be displayed in the Report. Currently, I have got the Total value in the Rport, but the issue is The user wants it be shown as Merged Cell . For Example

PO NUMBER ITEM PO COST

102 10 500 USD

20 #

104 10 600 USD

106 10 900 USD

20 #

If you see the above example , In the Report , it shows two Rows for each item. eventhough the Total PO Cost has been calculate using a routine, it displays, two rows in the End Report .The first item shows Total Value and the second item shows null Value. I want this Total PO Price to be merger for each PO Number. I hope it is clear.

Is it possible through Workbooks ?

Regards,

Samir