# Help with making a section in the app
**URL:** https://community.glideapps.com/t/help-with-making-a-section-in-the-app/60108
**Category:** Ask for Help
**Created:** [April 4, 2023, 2:49am UTC](https://community.glideapps.com/t/help-with-making-a-section-in-the-app/60108 "2023-04-04T02:49:15Z")
**Posts on this page:** 20
**Page:** 2
### Author:  [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [April 4, 2023, 5:13am UTC](https://community.glideapps.com/t/help-with-making-a-section-in-the-app/60108/21 "2023-04-04T05:13:20Z")
How many days do you want to see at a time? One week? One month? The entire sheet?
What if you could select a month like “January” and see all the totals for the days in January. Would that work?
---
### Author:  [@Jenish\_Shrestha](https://community.glideapps.com/u/Jenish_Shrestha)
#### Post date: [April 4, 2023, 5:29am UTC](https://community.glideapps.com/t/help-with-making-a-section-in-the-app/60108/22 "2023-04-04T05:29:10Z")
No that wont do it. I need the total for each day.
---
### Author:  [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [April 4, 2023, 5:33am UTC](https://community.glideapps.com/t/help-with-making-a-section-in-the-app/60108/23 "2023-04-04T05:33:21Z")
Yes I understand. The total would be by each day. How many days do you need to see on screen at one time?
Would it work if you select January and see all the days in January or select February and see all the days in February?
---
### Author:  [@Jenish\_Shrestha](https://community.glideapps.com/u/Jenish_Shrestha)
#### Post date: [April 4, 2023, 5:35am UTC](https://community.glideapps.com/t/help-with-making-a-section-in-the-app/60108/24 "2023-04-04T05:35:54Z")
Yeah that won’t be a problem.
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [April 4, 2023, 5:44am UTC](https://community.glideapps.com/t/help-with-making-a-section-in-the-app/60108/25 "2023-04-04T05:44:50Z")
Done:
> **[Sum daily sales](https://sum-daily-sales.glide.page)**
---
### Author:  [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [April 4, 2023, 5:48am UTC](https://community.glideapps.com/t/help-with-making-a-section-in-the-app/60108/26 "2023-04-04T05:48:34Z")
👑
---
### Author:  [@Jenish\_Shrestha](https://community.glideapps.com/u/Jenish_Shrestha)
#### Post date: [April 4, 2023, 5:51am UTC](https://community.glideapps.com/t/help-with-making-a-section-in-the-app/60108/27 "2023-04-04T05:51:18Z")
Wow this is kind of it
---
### Author:  [@Jenish\_Shrestha](https://community.glideapps.com/u/Jenish_Shrestha)
#### Post date: [April 4, 2023, 5:54am UTC](https://community.glideapps.com/t/help-with-making-a-section-in-the-app/60108/28 "2023-04-04T05:54:34Z")
How do I do it ?
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [April 4, 2023, 6:08am UTC](https://community.glideapps.com/t/help-with-making-a-section-in-the-app/60108/29 "2023-04-04T06:08:42Z")
You have to generate a JSON file from the data and use JavaScript to sum the same dates.
---
### Author:  [@Jenish\_Shrestha](https://community.glideapps.com/u/Jenish_Shrestha)
#### Post date: [April 4, 2023, 6:17am UTC](https://community.glideapps.com/t/help-with-making-a-section-in-the-app/60108/30 "2023-04-04T06:17:21Z")
could you provide me a copy of your work ?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [April 5, 2023, 12:09am UTC](https://community.glideapps.com/t/help-with-making-a-section-in-the-app/60108/31 "2023-04-05T00:09:19Z")
I still kind of don’t understand the ultimate desired outcome here. Is it basically just a sum of each day’s sales?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [April 5, 2023, 12:14am UTC](https://community.glideapps.com/t/help-with-making-a-section-in-the-app/60108/32 "2023-04-05T00:14:18Z")
This looks to me like it should simply be a trunc(date) in a math column, a template to join the date with the user, then a relation linking the template to itself. Follow that with a rollup to sum the total for each user per day.
Possibly combined with the logic to only show the sum in unique rows and a filter the list to those unique rows.
Haven’t really studied the problem here, but seems easily doable without getting into javascript.
---
### Author:  [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [April 5, 2023, 12:54am UTC](https://community.glideapps.com/t/help-with-making-a-section-in-the-app/60108/33 "2023-04-05T00:54:55Z")
That’s how I understood it… just a sum of each days sales. I was thinking along the lines of what @Jeff_Hager just suggested and additionally add a choice component to filter the relation by month.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [April 5, 2023, 12:55am UTC](https://community.glideapps.com/t/help-with-making-a-section-in-the-app/60108/34 "2023-04-05T00:55:48Z")
Yeah, I don’t understand why there needs to be a more complex solution than a relation + rollup here.
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [April 5, 2023, 1:02am UTC](https://community.glideapps.com/t/help-with-making-a-section-in-the-app/60108/35 "2023-04-05T01:02:15Z")
I would love to se the easy sololution to reproduce my App JavaScript, i think you gonna have to craete a spider web of relations, rollups and if else columns 😉
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [April 5, 2023, 1:10am UTC](https://community.glideapps.com/t/help-with-making-a-section-in-the-app/60108/36 "2023-04-05T01:10:20Z")
Isn’t this the same result?
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [April 5, 2023, 1:28am UTC](https://community.glideapps.com/t/help-with-making-a-section-in-the-app/60108/37 "2023-04-05T01:28:15Z")
That is a perfect solution @ThinhDinh. I forgot that you could sum relations! And it has 1 column less than mine, LOL… Good Job!
But I still prefer JavaScript and transforming data to JSON. It will give more options for advanced calculations and filtering, It is just way easier to deal with JSON.
---
### Author:  [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [April 5, 2023, 2:42am UTC](https://community.glideapps.com/t/help-with-making-a-section-in-the-app/60108/38 "2023-04-05T02:42:27Z")
19 Columns but I included a choice, running total and a list collection 😉
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [April 5, 2023, 2:57am UTC](https://community.glideapps.com/t/help-with-making-a-section-in-the-app/60108/39 "2023-04-05T02:57:09Z")
19 columns… LOL. You have a lot of time to spare 😉
---
### Author:  [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [April 5, 2023, 3:11am UTC](https://community.glideapps.com/t/help-with-making-a-section-in-the-app/60108/40 "2023-04-05T03:11:40Z")
Trying to earn my keep amongst legends… 🤓
The majority of the bulk is in the running total. In the past I’ve tried JavaScript for a running total but there were some edge cases where it broke.
I do think JavaScript is a very valuable tool and I need to learn more. Will you teach me some of your ways @Uzo?
[Previous page](https://community.glideapps.com/t/help-with-making-a-section-in-the-app/60108.md?page=1)
[Next page](https://community.glideapps.com/t/help-with-making-a-section-in-the-app/60108.md?page=3)