SUM Revenue Totals By Customer - Need Help

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?

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

you can see the ‘live’ table here:

Good luck!

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