SUM Revenue Totals By Customer - Need Help

[Unseen]

I have a table called “Time Assignments”

Project Name (Linked field to Project table)
Month
Revenue

Example records:
Acme Shop, August 2020, $1500
Acme Shop, August 2020, $1200
Joe Smoe, August 2020, $750
Joe Smoe, August 2020, $750
Joe Smoe, August 2020, $1150
Crystal Palace, August 2020, $500
Acme Shop, September 2020, $1500
Acme Shop, September 2020, $1200
Joe Smoe, September 2020, $1150
Crystal Palace, September 2020, $500

I want to sum the total revenue by Customer Name and Month in another table (Calc). So I want to see…
Acme Shop, August 2020, $2700
Acme Shop, September 2020, $2700
Joe Smoe, August 2020, $2650
Joe Smoe, September 2020, $1150
Crystal Palace, August 2020, $500
Crystal Palace, September 2020, $500

Any ideas?

[Chen_Pro]

Hi there,
I think you can easily do it with groups:

you can see the ‘live’ table here:

Airtable

Grid view - Airtable

Explore the "Grid" view on Airtable.

Good luck!