Subtotal problem in Excel Template
We are building an EXCEL template for BI Publisher, attached are our xml data file and the Excel template. we need to have subtotal for Task total by task number/expenditure type (see the red circle) and subtotal for project. We created groupings in XDO_METADATA etc.. but for the Task Total, we always get the amount of the first record, not total for all records in a task.
Could someone help on this?
Thanks a lot