Unfortunately, there is no automated way in Airtable to create a “dashboard” table like what you created. That’s because there is no way to automatically link records in Airtable.
The only way that you can link records in Airtable is by MANUALLY linking them. (Unless you’re converting a text field to a linked field, in which case Airtable does a one-time-only linking for you.)
Your best bet for accomplishing this would be to put ALL of your expenses into ONE table called “Expenses”, as @Mohamed_Swellam said. Then, you would add a field called “Category”, so you could tag each one of your expenses with their own category.
(Alternatively, your categories could live within their own table called “Category”, and you could link each expense to a category. But if you’re just starting out with Airtable, it would probably be easier to just keep everything together in one table for now.)
Then, once you’ve got all of your expenses in one table with their Categories attached to them, then you could group your Expenses table by Category — and Airtable even has the built-in ability to automatically summarize (total) grouped categories for you. The choice for that will appear right in the Grouped header itself.
Also, once all of your expenses are together in one table, that gives you the opportunity to do other cool things too, like filtering your records, or applying a pivot table block to them so you can summarize your expenses in a variety of different ways.
