I’m fairly new to airtable, so please bear with me :slightly_smiling_face:
I’m trying to pull some aggregated data into a new table. Receipts are tracked into a table “Expenses” with a field for the amount, a field for the name of the person who made the expense and a field for the payment method (cash, bank transfer, paypal, etc.) - amongst other fields not related to my problem. Now I would like to get the sums of amounts aggregated by person and payment method.
With SQL I’d run “SELECT person, method, SUM(amount) FROM expenses GROUP BY person, method”
Ideally the table with the aggregated data is updated dynamically when rows are appended to the expenses table.
I’m aware of the possibility to create a view that does exactly what the SQL query does. However, I need to append the queried data with additional fields.
Any help on this is greatly appreciated.