# How to total different group values in Big Tables?

**URL:** <https://community.glideapps.com/t/how-to-total-different-group-values-in-big-tables/74845>\
**Category:** Ask for Help\
**Created:** [July 12, 2024, 11:21am UTC](https://community.glideapps.com/t/how-to-total-different-group-values-in-big-tables/74845 "2024-07-12T11:21:46Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mcjmccartney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mcjmccartney/32/70883_2.png) [@mcjmccartney](https://community.glideapps.com/u/mcjmccartney)\
**Post date:** [July 12, 2024, 11:21am UTC](https://community.glideapps.com/t/how-to-total-different-group-values-in-big-tables/74845/1 "2024-07-12T11:21:46Z")

</div>

Hi all,

I have a column that has records for July 2024, August 2024, September 2024 etc…

Each of these records has a quote value that I would like to roll up and sum for each group ie. July 2024 is £125 with 4 records, then maybe 6 records in August have a total of £230 etc.

Here is a screenshot of the column that I would like to group my records with:

 ![Screenshot 2024-07-12 at 12.23.29](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/4/54a8354f8a6bf55ed783409871a58b4b87faa007.png)

I’m using Big Tables and struggling to group these up by the month and get the sum for each.

Hope this makes sense and thank you!

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 13, 2024, 12:55am UTC](https://community.glideapps.com/t/how-to-total-different-group-values-in-big-tables/74845/2 "2024-07-13T00:55:19Z")

</div>

- Create a relation from the Month & Year column to itself, return multiple matches.
- Create a rollup to count the number of records.
- Create a rollup to sum the amount.
- Create 2 pluralize columns to properly pluralize the records and amount of money, or use a JavaScript column, or an Excel column, there’s a lot of way to get to “£125 with 4 records”.

If something doesn’t work, please let us know, and be aware of some limitations with Big Tables.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/1/419fc816fe1da34fef82f8b128cc73e25ff820ef.png)

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [July 20, 2024, 12:55am UTC](https://community.glideapps.com/t/how-to-total-different-group-values-in-big-tables/74845/3 "2024-07-20T00:55:27Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.