Apologies in advance if my explanation isn’t great, but I will demonstrate what I need in an example:
I have two tables in one base. One is called Budget and the other is called Transactions.
In Budget, I store
In Transaction, I store
Category in Transaction is linked to the one in Budget (and by default, as a result I have another field in Budget called
Transactions that shows me the list of all transactions that are tagged with a specific category).
Current Spend to show me the sum of all
Amount fields from the table Transactions, but for each category.
So, if I have three rows in Transactions that say
Netflix, Subscriptions, $10
Spotify, Subscriptions, $10
Disneyland, Holiday Spend, $30
then for each category in the Budget table I’d like to see the respective sums in the
Current Spend field (i.e. $20 for
Subscriptions and $30 for
In terms of Excel, I’d like a
In terms of SQL, I’d like a
SELECT SUM() FROM * WHERE *.
I’ve looked everywhere but can’t seem to find what I need.
Thank you so much in advance.