Hello,
I am trying to summarize each group in a list report, this list is created from a query that is generated from a Native SQL syntax. I tried sectioning then totaling, the totaling only comes at the end of the report. I tried grouping from left to right, still no totaling for each group, just at the end of the report. I tried changing the summary aggregation for each data item (except the ones I want to total which are measures) still did not work, only totals at the end of the page.
I have stages and I want to total the $ amount for each stage under the end of the stage group. Not the total $ amount for the whole list.
Does anyone have any idea how to approach this?
The summarize tool should have done that if you added the summary after adding the grouping.
Open List Headers and Footers and make sure you have group footers checked for the groups you want totaled. Then add the totals. One way to do this is to copy the objects from the table summary into the group summary. There may be an easier way.