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
104 10 600 USD
106 10 900 USD
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 ?