Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Sep 01, 2020 11:31 AM
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?
Sep 03, 2020 08:55 AM
Hi there,
I think you can easily do it with groups:
you can see the ‘live’ table here:
Good luck!