Help

SUM Revenue Totals By Customer - Need Help

Topic Labels: Base design
654 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Unseen
4 - Data Explorer
4 - Data Explorer

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?

1 Reply 1
Chen_Pro
6 - Interface Innovator
6 - Interface Innovator

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

you can see the ‘live’ table here:

Good luck!