I want to trigger some calculations from a specific spendings table in the user table.
Table for tracking spendings:
- each entry per spending per user
- category filter
In the user table:
- counting all entries already works, also calculation for total amount
How can I count for each user number of entries and total amount by CATEGORY?