Add ability to designate which groupings the aggregate fields should total rather than just first or all.
We currently have the option to show the aggregate totals on the first group or all groups. I have a need to exclude the totals from the first two groups on my report and just show it on the last group. The totals are wrong on the first two groups because the calculation is MAX(field) which works at the lowest level perfectly, but not higher. The request is to have a list of the fields that are grouped on the report and checkboxes to indicate which groups the aggregate should appear.
1
vote
Jane Grant
shared this idea