# Filter within a period **URL:** \ **Category:** Ask for Help\ **Created:** [September 19, 2021, 10:36am UTC](https://community.glideapps.com/t/filter-within-a-period/32006 "2021-09-19T10:36:45Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Sales\_Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sales_manager/32/16172_2.png) [@Sales\_Manager](https://community.glideapps.com/u/Sales_Manager)\ **Post date:** [September 19, 2021, 10:36am UTC](https://community.glideapps.com/t/filter-within-a-period/32006/1 "2021-09-19T10:36:45Z")
can I create filter in glide for total sales within a certain period For example: from 1 Sept to 14 Sep ![لقطة الشاشة 2021-09-19 133550](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/c/ac17fb07d85daa78c1898559f19d6803f61aa424.png) ![لقطة الشاشة 2021-09-19 133608](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/5/f5441d120e0ffa0782d64b5622f63d6f9e1e6eed.png) ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [September 19, 2021, 11:22am UTC](https://community.glideapps.com/t/filter-within-a-period/32006/2 "2021-09-19T11:22:21Z")
Sure! There are probably a few ways to do this, but here’s what comes to mind first: - create two user specific date columns to capture to From and To dates - create an IFTHEN column that checks if the sales date is on or after the From date, and then another condition for sales on or before the To date - return something like “true” - in your screen, make an inline list to show the results and filter it to only show “true” results ---
**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:** [September 19, 2021, 11:36am UTC](https://community.glideapps.com/t/filter-within-a-period/32006/3 "2021-09-19T11:36:43Z")
I think the OP also wants to sum the amounts of the filtered list, so maybe a couple of extra steps required, ie: - Create a template column with the single word `true` - Create a multi-relation column joining the template column to the if-then-else column - Create a rollup column, taking the sum of amounts through that relation ---
**Author:** ![Sales\_Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sales_manager/32/16172_2.png) [@Sales\_Manager](https://community.glideapps.com/u/Sales_Manager)\ **Post date:** [September 19, 2021, 11:42am UTC](https://community.glideapps.com/t/filter-within-a-period/32006/4 "2021-09-19T11:42:48Z")
How do I make Glide give me the row totals on the given date ---
**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:** [September 19, 2021, 12:14pm UTC](https://community.glideapps.com/t/filter-within-a-period/32006/5 "2021-09-19T12:14:13Z")
See my reply above ⬆ ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [September 19, 2021, 1:57pm UTC](https://community.glideapps.com/t/filter-within-a-period/32006/6 "2021-09-19T13:57:59Z")
Haha you’re very right! I had that on my mind but somehow I didn’t finish typing my thoughts. Thanks for finishing this one off! ---
**Author:** ![Sales\_Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sales_manager/32/16172_2.png) [@Sales\_Manager](https://community.glideapps.com/u/Sales_Manager)\ **Post date:** [September 19, 2021, 3:06pm UTC](https://community.glideapps.com/t/filter-within-a-period/32006/7 "2021-09-19T15:06:27Z")
I understand the first two steps, but what is the equation that will sum the rows between the given date? ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [September 19, 2021, 3:08pm UTC](https://community.glideapps.com/t/filter-within-a-period/32006/8 "2021-09-19T15:08:13Z")
The key is to create a multiple relation that pulls all the results of the search. From there, you create a Rollup column — in a rollup, you can choose to perform a few different operations on the data — count, sum, etc. In your case, sum the data the multiple relation gathers. ---
**Author:** ![Sales\_Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sales_manager/32/16172_2.png) [@Sales\_Manager](https://community.glideapps.com/u/Sales_Manager)\ **Post date:** [September 19, 2021, 3:45pm UTC](https://community.glideapps.com/t/filter-within-a-period/32006/9 "2021-09-19T15:45:06Z")
I tried and it didn’t work, is there a similar video that you can help me with please? ---
**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:** [September 19, 2021, 4:10pm UTC](https://community.glideapps.com/t/filter-within-a-period/32006/10 "2021-09-19T16:10:50Z")
Can you show what you did to see why it didn’t work? ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [September 19, 2021, 5:56pm UTC](https://community.glideapps.com/t/filter-within-a-period/32006/12 "2021-09-19T17:56:54Z")
“Rollup” can be used to do calculations through the results of multiple relations. ---
**Author:** ![akshay\_more](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/akshay_more/32/76873_2.png) [@akshay\_more](https://community.glideapps.com/u/akshay_more)\ **Post date:** [September 20, 2021, 7:02am UTC](https://community.glideapps.com/t/filter-within-a-period/32006/13 "2021-09-20T07:02:43Z")
You can also calculate through the Google sheet formula… ![Total amount](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/c/eca8bdb2cdabb856b37c13acd51bcf0342adcc77.png) ---
**Author:** ![Sales\_Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sales_manager/32/16172_2.png) [@Sales\_Manager](https://community.glideapps.com/u/Sales_Manager)\ **Post date:** [September 20, 2021, 8:38am UTC](https://community.glideapps.com/t/filter-within-a-period/32006/14 "2021-09-20T08:38:01Z")
It has been successfully implemented. ![لقطة الشاشة 2021-09-20 113327](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/8/78b5032d605831e9e2409541415d07d42ebce3ad.png) ![لقطة الشاشة 2021-09-20 113524](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/6/d658fd47683ada3131fc8077877183149801d000.png)