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 Jan 1

413 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?

asked Jan 1 by Sentener (170 points)

1 Answer

0vote

polle Points46140

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.

answered Jan 2 by polle (46.1k points)

selected Jan 10 by Sentener

1vote

Sentener commented Jan 2

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

commented Jan 2 by Sentener (170 points)

0vote

polle commented Jan 2

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?

commented Jan 2 by polle (46.1k points)

1vote

Sentener commented Jan 2

I want to display that sum inside the account table.

commented Jan 2 by Sentener (170 points)

0vote

polle commented Jan 2

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.

commented Jan 2 by polle (46.1k points)

1vote

Sentener commented Jan 3

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

commented Jan 3 by Sentener (170 points)

0vote

polle commented Jan 9

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.

commented Jan 9 by polle (46.1k points)

Please log in or register to answer this question.

Exclusive for Notion Answers Users

• Dynamic Calendar Icon | Info | Download
Add yours here

Extend Notion Powers

⇧Your Product or Service Here⇧

...

Notion Answers

Register & Ask

Get answers

Vote and select answers

Question

How do i rollup by months

Please log in or register to add a comment.

1 Answer

Sentener commented Jan 2

polle commented Jan 2

Sentener commented Jan 2

polle commented Jan 2

Sentener commented Jan 3

polle commented Jan 9

Please log in or register to add a comment.

Please log in or register to answer this question.

Exclusive for Notion Answers Users

Recent Activities

scarmonies asked 10 hours ago

prabhakaratnumici asked 10 hours ago

joga commented 1 day ago

Vira asked 5 days ago

polle commented 6 days ago

Extend Notion Powers

Tags

Question

How do i rollup by months

Please log in or register to add a comment.

1 Answer

Sentener commented Jan 2

polle commented Jan 2

Sentener commented Jan 2

polle commented Jan 2

Sentener commented Jan 3

polle commented Jan 9

Please log in or register to add a comment.

Please log in or register to answer this question.

Related questions

Without Answer

Exclusive for Notion Answers Users

Recent Activities

scarmonies asked 10 hours ago

prabhakaratnumici asked 10 hours ago

joga commented 1 day ago

Vira asked 5 days ago

polle commented 6 days ago

Extend Notion Powers

Tags

Connect