Try to build group left report with Table Wizard.
With BI Publisher Table Wizard on Step --> How would you like to group your Report?
You can select group left option to build your report and after that implement sum logic for no of item
Thanks a lot for the reply. Is it also possible to repeat the grouped elements on all the rows ? So effectively I would like to show a flat table just like the output I would get from SQL Query. For ex, in the solution posted in your reference link, I would like to have "Current" and "Future" repeated on all the rows.
Would I have to use xslt/xsl-fo to get the desired output ?
Can't say anything about it.
How you are geting xml like this, is source RDF report data model.
I tried your provided XML as i advise earlier, it not working, even I tried same logic on your provided layout but couldn't get the desire out put.
See layout and fields detail here.
Can you try this?
quantity E E
Field codes as below:
This might be bit costly because of some traversing to parent level in group.