# 🤔 How to: Sort by month/ keep tally of month amount? (w/pic)

**URL:** https://community.glideapps.com/t/how-to-sort-by-month-keep-tally-of-month-amount-w-pic/66966
**Category:** Ask for Help
**Created:** [October 14, 2023, 3:35am UTC](https://community.glideapps.com/t/how-to-sort-by-month-keep-tally-of-month-amount-w-pic/66966 "2023-10-14T03:35:43Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![JamieErvin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jamieervin/32/57900_2.png) [@JamieErvin](https://community.glideapps.com/u/JamieErvin)
#### Post date: [October 14, 2023, 3:35am UTC](https://community.glideapps.com/t/how-to-sort-by-month-keep-tally-of-month-amount-w-pic/66966/1 "2023-10-14T03:35:43Z")

</div>

Hello!

For this project, the user will have a new starting amount each month. Each transaction should add to that.

However, they want to be able to search for any month and get the transactions AND the total of that search.

So far I have a Rollup \> Sum Column to keep the tally of the overall month.

Thanks

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/5/d52735cb52e1e663bdeddbc60c871b8d2cad105c.jpeg)

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [October 14, 2023, 12:56pm UTC](https://community.glideapps.com/t/how-to-sort-by-month-keep-tally-of-month-amount-w-pic/66966/2 "2023-10-14T12:56:40Z")

</div>

You’ll need to create “month values” that you can query against. Here’s a video that might show you what’s possible:

Glide: Dynamically Filter your Data by DATE RANGE (Part 2)

[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/0/407efc1f46f0c0d8207a5495c6473b4b0f30708b.jpeg "Glide: Dynamically Filter your Data by DATE RANGE (Part 2)") ](https://www.youtube.com/watch?v=AVSavEhdt6Y)

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [October 15, 2023, 12:13am UTC](https://community.glideapps.com/t/how-to-sort-by-month-keep-tally-of-month-amount-w-pic/66966/3 "2023-10-15T00:13:02Z")

</div>

“Search” is a bit dangerous here since you have too many ways to present a month value: Oct 2023, October 2023, 10/2023, 2023 Oct, 2023 October etc.

I would just show a choice component pointing to a user-specific column, and do the query method Robert presented above.