Hi,
I want to build an app for a person to keep an eye on her income and expenses.
Each of it (income and expenses) need to have several categories (fixed maximum of 8 each)
Each "record" will have this data : year, month, type (=income or expense), category, amount, description.
In the app, I want a 2 summary-tables that groups all categories of income and expenses (grouped by year / month / category). If possible with choice / switch option (income / expense)
Something like this :
TABLE - 1
YEAR | MONTH | total of INCOME | total of EXPENSES | balance
2023 jan 8888 9999 -1111
2023 feb 900 800 100
...
2023 dec ...
TABLE - 2 (here the user can choose between "income" or "expenses"
YEAR | MONTH | total of CAT_name_1 | total of CAT_name_2 | ... | total of CAT_name_8
2023 jan 111 333
2023 feb 1000 2000 100
...
2023 dec ...
I would appreciate if someone can help me how to start and how to calculate those totals and put them in a table.
Wim