Ask Questions

Connect

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

2votes

How do i rollup by months

Asked
207 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 (170 points)

1 Answer

0vote

polle Points42420

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 (42.4k points)
selected by

1vote

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 (170 points)

0vote

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 (42.4k points)

1vote

Sentener commented

I want to display that sum inside the account table.

by Sentener (170 points)

0vote

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 (42.4k points)

1vote

Sentener commented

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

by Sentener (170 points)

0vote

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 (42.4k points)

Please log in or register to answer this question.

Related questions

Without Answer

Exclusive for Notion Answers Users

Recent Activities

Extend Notion Powers

⇧Your Product or Service Here⇧
...

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