Toad World® Forums

Summary Grouping With A Calculated Field


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

I would suggest to use Pivot Grid in this case.

Here are the links to video tutorial and help topic how to use the Pivot Grid



The following post shows how to use Pivot Grid and it could also be useful for you