# Question: Column summaries with multiple groupings in a table

**URL:** <https://forums.knack.com/t/question-column-summaries-with-multiple-groupings-in-a-table/10912>\
**Category:** Get Answers\
**Created:** [August 23, 2021, 3:03pm UTC](https://forums.knack.com/t/question-column-summaries-with-multiple-groupings-in-a-table/10912 "2021-08-23T15:03:57Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![EricAlderman](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/ericalderman/32/761_2.png) [@EricAlderman](https://forums.knack.com/u/EricAlderman)\
**Post date:** [August 23, 2021, 3:03pm UTC](https://forums.knack.com/t/question-column-summaries-with-multiple-groupings-in-a-table/10912/1 "2021-08-23T15:03:57Z")

</div>

I thought it was possible for a table with a Column Summary to show that summary for each of the Groupings, if there are more than one.

For example, I want to group orders first by Current Supplier and then by Product, and I want to see a Total column summary for both groups.

Is this possible?

---

<div class="post-metadata">

**Author:** ![CarlHolmes](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/carlholmes/32/2814_2.png) [@CarlHolmes](https://forums.knack.com/u/CarlHolmes)\
**Post date:** [August 24, 2021, 8:14am UTC](https://forums.knack.com/t/question-column-summaries-with-multiple-groupings-in-a-table/10912/2 "2021-08-24T08:14:55Z")

</div>

Hi Eric,

This is a limitation of grouping, it will only add totals to one group.  
The attached shows a table grouped by pets for their clips.  
If you look at Millie on the first screenshot you will see the total cost of clips is £215.00.  
I have then grouped into this the Shampoo, I still get £215.00 but don’t get the breakdown of £30.00, £144.00 & £41.00 for the three different shampoos used.

It would be nice if there was the option to also total by the secondary group, but not at the moment. 😊

 ![01](https://us1.discourse-cdn.com/flex020/uploads/knack/original/1X/45174d19a6a5011f8c0067519a736f8fb82f4e25.jpeg)  
 ![02](https://us1.discourse-cdn.com/flex020/uploads/knack/original/1X/fd03f781c7f5f746b9acb3df45fdda389fe9a7c6.jpeg)

---

<div class="post-metadata">

**Author:** ![EricAlderman](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/ericalderman/32/761_2.png) [@EricAlderman](https://forums.knack.com/u/EricAlderman)\
**Post date:** [October 15, 2021, 3:46pm UTC](https://forums.knack.com/t/question-column-summaries-with-multiple-groupings-in-a-table/10912/3 "2021-10-15T15:46:37Z")

</div>

Thanks @CarlHolmes - agreed!

---

<div class="post-metadata">

**Author:** ![andrewstee38626](https://avatars.discourse-cdn.com/v4/letter/a/dfb087/32.png) [@andrewstee38626](https://forums.knack.com/u/andrewstee38626)\
**Post date:** [September 9, 2022, 10:28am UTC](https://forums.knack.com/t/question-column-summaries-with-multiple-groupings-in-a-table/10912/4 "2022-09-09T10:28:55Z")

</div>

I need this quite often - would be a good upgrade

---

<div class="post-metadata">

**Author:** ![StephenChapman](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/stephenchapman/32/1759_2.png) [@StephenChapman](https://forums.knack.com/u/StephenChapman)\
**Post date:** [November 25, 2024, 10:54pm UTC](https://forums.knack.com/t/question-column-summaries-with-multiple-groupings-in-a-table/10912/5 "2024-11-25T22:54:58Z")

</div>

For all new people stumbling on this, I’ve posted a solution [here](https://forums.knack.com/t/subtotal-for-second-level-grouping/18237/3).