HI all, I am creating a report with a sub report.
The sub report will pass a value to the same report detail. At the end, I will want to Sum up the value. I have issue adding up the value as I Share the value from the sub report.
Can anyone advise what is the work around?
In my report, I have a group which is "Category". I need to have the sub total of Category and grand total.
My share value in the main report named as "ShareAmt".
My report looking something like this .

I am unable to get the Total amount of 300 and 600 and grand total of 900.
Tried to created another sub report, the sub total for dinner only show 200and the sub total for lunch always show 100 only.
Noticed for total it always only show the last invoice amount.
Please advise.
Thanks!