Single row result for compounding infoObject in BEx Query

Hello Experts,

I have a query related to Componding InfoObject.

There is an InfoObject Material which is having a compounding attribute Plant. I have to get the number of material sold.I was getting the report as below:

Material Number of material sold P1/M1 50 P2/M1

30

I browsed through various links as follows:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/908ec141-d39f-2e10-50b0-c4518fc975ac?QuickLink=index&…

How to Hide Compounding object from bex display

https://scn.sap.com/thread/1131086

Using these docs, I am able to get the result as below:

Material Number of material sold M1 50 M1

30

However my requirement is to get the report as below:

Material Number of material sold M1 80

Please help me to understand how we can achieve this in BEx query.

Thanks and Regards,

Nitesh