Notion Answers

Help between Notion users


Register & Ask

It's free & easy

Get answers

Answers, votes & comments

Vote and select answers

Receive points, vote and give the solution

Question

3votes

How do i rollup by months

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?

1 Answer

1vote

polle Points77470

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.

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

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?

2votes

Sentener commented

I want to display that sum inside the account table.

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.

2votes

Sentener commented

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

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.

Please log in or register to answer this question.

...

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!

Connect