# Calculating total monthly

**URL:** https://community.glideapps.com/t/calculating-total-monthly/72096
**Category:** Ask for Help
**Created:** [March 27, 2024, 3:56pm UTC](https://community.glideapps.com/t/calculating-total-monthly/72096 "2024-03-27T15:56:41Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![GarryVa](https://avatars.discourse-cdn.com/v4/letter/g/c67d28/32.png) [@GarryVa](https://community.glideapps.com/u/GarryVa)
#### Post date: [March 27, 2024, 3:56pm UTC](https://community.glideapps.com/t/calculating-total-monthly/72096/1 "2024-03-27T15:56:41Z")

</div>

Hello Gliders, I’d like to display sum of prices depending of month column.

In other words, I’d like to automate total calculation of commissions at the end of each month. Here is a screenshot :

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/a/fa77c4667e7e9ff40f9712775e014e0e70975357.png)

And here a preview of what I would like to get :  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/d/8dc6332319e15c1890a172122f68e907b18ea0cd.png)

How to do it? Do I need to create another table?

Thank you

---

<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: [March 27, 2024, 7:59pm UTC](https://community.glideapps.com/t/calculating-total-monthly/72096/2 "2024-03-27T19:59:22Z")

</div>

Use the same table or create another table with the month. Then create a relation linking the months together. Then create a Rollup column to sum the amounts from the relation.

---

<div class="post-metadata">

### Author: ![GarryVa](https://avatars.discourse-cdn.com/v4/letter/g/c67d28/32.png) [@GarryVa](https://community.glideapps.com/u/GarryVa)
#### Post date: [March 28, 2024, 10:42am UTC](https://community.glideapps.com/t/calculating-total-monthly/72096/3 "2024-03-28T10:42:27Z")

</div>

Ok thank you @Jeff_Hager , it works. But do you have any idea to display only one item each month ?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/c/2c541559b6d1dd6df88160bcfe6b7c979f825cdb.png)

I tried to use “Limit number of items” option but I’m not sure that it will show one item by month :  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/5/256f7bf64a60c6126c19f10bb6d086ee8b55d0b1.png)

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 28, 2024, 11:04am UTC](https://community.glideapps.com/t/calculating-total-monthly/72096/4 "2024-03-28T11:04:37Z")

</div>

- Add a RowID column to your table
- Add a Single Value column that selects the first RowID value via the relation column.
- Add an if-then-else column:  
– If RowID is Single Value RowID, then Rollup Amount
- Use the if-then-else column as a filter on your collection - only show rows where it is not empty.

---

<div class="post-metadata">

### Author: ![GarryVa](https://avatars.discourse-cdn.com/v4/letter/g/c67d28/32.png) [@GarryVa](https://community.glideapps.com/u/GarryVa)
#### Post date: [March 28, 2024, 1:56pm UTC](https://community.glideapps.com/t/calculating-total-monthly/72096/5 "2024-03-28T13:56:08Z")

</div>

Thank you all @Jeff_Hager and @Darren_Murphy , it works perfectly !!

---

<div class="post-metadata">

### Author: ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)
#### Post date: [March 28, 2024, 2:00pm UTC](https://community.glideapps.com/t/calculating-total-monthly/72096/6 "2024-03-28T14:00:43Z")

</div>

Great technique - thanks Jeff and Darren

---

<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: [April 4, 2024, 2:01pm UTC](https://community.glideapps.com/t/calculating-total-monthly/72096/7 "2024-04-04T14:01:40Z")

</div>

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