How to total different group values in Big Tables?

Ask for Help
1

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
Screenshot 2024-07-12 at 12.23.29436×1480 67.2 KB

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!

2
  • 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
image757×552 59.8 KB

2 Likes
3

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