# Summary Grouping With A Calculated Field

**URL:** <https://forums.toadworld.com/t/summary-grouping-with-a-calculated-field/40552>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [February 5, 2018, 5:26am UTC](https://forums.toadworld.com/t/summary-grouping-with-a-calculated-field/40552 "2018-02-05T05:26:36Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![tom\_60844](https://avatars.discourse-cdn.com/v4/letter/t/aca169/32.png) [@tom\_60844](https://forums.toadworld.com/u/tom_60844)\
**Post date:** [February 5, 2018, 5:26am UTC](https://forums.toadworld.com/t/summary-grouping-with-a-calculated-field/40552/1 "2018-02-05T05:26:36Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![AlekseyBazhenov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@AlekseyBazhenov](https://forums.toadworld.com/u/AlekseyBazhenov)\
**Post date:** [February 7, 2018, 9:59am UTC](https://forums.toadworld.com/t/summary-grouping-with-a-calculated-field/40552/2 "2018-02-07T09:59:38Z")

</div>

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/1690)

[http://www.toadworld.com/products/toad-data-point/m/media-library/1698](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](http://dev.toadfordataanalyst.com/webhelp/default.htm#Reporting/Pivot_Grids/Pivot_Grid.htm%3FTocPath%3DCreate%20Pivot%20Grids%7C _____ 1)

Regards

Aleksey

---

<div class="post-metadata">

**Author:** ![AlekseyBazhenov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@AlekseyBazhenov](https://forums.toadworld.com/u/AlekseyBazhenov)\
**Post date:** [February 8, 2018, 10:00am UTC](https://forums.toadworld.com/t/summary-grouping-with-a-calculated-field/40552/3 "2018-02-08T10:00:01Z")

</div>

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](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