# SUM By date

**URL:** https://community.glideapps.com/t/sum-by-date/73843
**Category:** Ask for Help
**Created:** [June 3, 2024, 8:50pm UTC](https://community.glideapps.com/t/sum-by-date/73843 "2024-06-03T20:50:05Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Diego\_Carvejani](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/diego_carvejani/32/76042_2.png) [@Diego\_Carvejani](https://community.glideapps.com/u/Diego_Carvejani)
#### Post date: [June 3, 2024, 8:50pm UTC](https://community.glideapps.com/t/sum-by-date/73843/1 "2024-06-03T20:50:05Z")

</div>

Hi Guys,

I have a personal financial app and i would like to show Month Income and Month Expense in a Big Number or something like that.

I have a table Transactions where i have added incomes and expenses per month (Income = Recebíveis - Expenses = Gastos) and i would like to SUM incomes per month in a column and expenses per month in another column, how can i do it?

 ![Screenshot 2024-06-03 174809](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/a/ba2a662b46dad3870a4ab83275d9d836ee272ccb.jpeg)

I created a classification table too

 ![Screenshot 2024-06-03 175059](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/e/3ecf7a3b410c5adc5c345d49affb1101677c07aa.png)

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [June 3, 2024, 10:39pm UTC](https://community.glideapps.com/t/sum-by-date/73843/2 "2024-06-03T22:39:49Z")

</div>

Create a Query column that filters based on your Month Year and Classification values. Then you can create a Rollup column that uses that Query to Sum the Amount.

---

<div class="post-metadata">

### Author: ![Diego\_Carvejani](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/diego_carvejani/32/76042_2.png) [@Diego\_Carvejani](https://community.glideapps.com/u/Diego_Carvejani)
#### Post date: [June 4, 2024, 1:53am UTC](https://community.glideapps.com/t/sum-by-date/73843/4 "2024-06-04T01:53:22Z")

</div>

Thanks Jefff!

---

<div class="post-metadata">

### Author: ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)
#### Post date: [June 11, 2024, 1:53am UTC](https://community.glideapps.com/t/sum-by-date/73843/5 "2024-06-11T01:53:58Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.