How to total different group values in Big Tables?

[mcjmccartney]

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:

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!

[ThinhDinh]

• 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.