Toad World® Forums

Summary Grouping With A Calculated Field

Hello,

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

http://www.toadworld.com/products/toad-data-point/m/media-library/1690

http://www.toadworld.com/products/toad-data-point/m/media-library/1698

http://dev.toadfordataanalyst.com/webhelp/default.htm#Reporting/Pivot_Grids/Pivot_Grid.htm%3FTocPath%3DCreate%20Pivot%20Grids%7C_____1

Regards

Aleksey

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

http://www.toadworld.com/products/toad-data-point/b/weblog/archive/2018/02/08/create-and-automate-pivot-grids-in-toad-data-point-4-3

Regards

Aleksey