I have a TDP report that groups figures based on location where I have a summary at the bottom of each group.
In that report there are 2 columns that are percentages calculated by the SQL, but I can’t create a summary in the group footer using that it seems.
I have instead tried a calculated field, I can get a report total but I can’t limit the scope to just that location for the location total.
My question is how would I do that? Thank you in advance.
The report format is like this
Location (grouped by) | Total Orders | Orders with A | % of Total | Orders with B | % of Total