Ask Questions

Connect

3votes

How do i rollup by months

Asked
7866 Views
1 Answers
Solved

I am trying to make a financial dashboard. I have currently 4 databases. Accounts, Expense, Income and Budget. I am trying to display monthly income in my accounts table using rollup but i keep getting the sum of current and past months. Any advice on how to solve this?

by Sentener (180 points)

1 Answer

1vote

polle Points102630

You need to filter your view by month, there is no need to use a Rollup for that.

That way you will just see by month everything and at the bottom you can use the calculate options to see the totals.

by polle (103k points)
selected by

2votes

Sentener commented

n my account database, i want to see my monthly expense and income.

https://branched-scarer-bb8.notion.site/Finance-Tracker-f58a30c3c4fa4d26921d75e1f0b81ffb

This is what i have currently. but i have no idea of how to display the total income and expense, while having a monthly income and expense under acco

by Sentener (180 points)

1vote

polle commented

In the income section you have a monthly view and there is the sum of the Amount column.

Below that you have another table for Date and that shows correctly the sum for each month in the rollup.

What is the problem?

by polle (103k points)

2votes

Sentener commented

I want to display that sum inside the account table.

by Sentener (180 points)

1vote

polle commented

You have to also relate the Date database to account, so accounts can have the rollup showing the sum, exactly as you have it in income.

by polle (103k points)

2votes

Sentener commented

ahh i see. Thanks. then to show yearly i should create a year table as well?

by Sentener (180 points)

1vote

polle commented

If you plan to have years and count them, like use the information by year as well, then yes, that would be the best to do.

Otherwise just pull everything with no filters at all.

If you consider the question solved, please select the answer to mark it.

by polle (103k points)

Please log in or register to answer this question.

Related questions

Without Answer

Recent Activities

...

Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!

Tags

Connect