# How do I separate out items by month (when using COLLECTION component) **URL:** \ **Category:** Ask for Help\ **Created:** [April 20, 2022, 5:27pm UTC](https://community.glideapps.com/t/how-do-i-separate-out-items-by-month-when-using-collection-component/40962 "2022-04-20T17:27:53Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Js\_H](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/js_h/32/41578_2.png) [@Js\_H](https://community.glideapps.com/u/Js_H)\ **Post date:** [April 20, 2022, 5:27pm UTC](https://community.glideapps.com/t/how-do-i-separate-out-items-by-month-when-using-collection-component/40962/1 "2022-04-20T17:27:53Z")
Hi there, I am trying to create monthly sales amount, expenses’ report page for my client. (Please see below snap shot) When client clicks and enters into each month’s page, those sales amount, expenses should sync the numbers by each month, but it failed because when I set December’s data for December’s page by using ‘collection’ component, resulting in the situation where the above December’s date automatically synchronize all other months’ data. Please advise how to solve this problem. Thanks! ![Screenshot Glide page](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/2/5292ab636cc1669dd0b7d40e141d7794b5db77e3.png) ![Screenshot Glide page 2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/3/c3d388ba560315a568bcb6732bdd99fbfeb7b446.png) ![Screenshot Glide page 3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/c/ac4f55b2ff38846dac1b7bcd1ccc68204fd2357d.png) ---
**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:** [April 21, 2022, 12:54am UTC](https://community.glideapps.com/t/how-do-i-separate-out-items-by-month-when-using-collection-component/40962/2 "2022-04-21T00:54:31Z")
I think that is an odd way of managing your data in your last screenshot, but if you want to keep that structure, my advise is to: - On entry to each month’s view, set that month’s name to a column in your user profiles table (if you have one). - Bring that value over to the Sales Amount table using a single value column or a template column. Let’s call it “Viewing Month”. - Create an If Then Else column in the Sales Amount table, create as many logic branches as you need, let’s say if “Viewing Month” is Jan-2022 then return the Jan-2022 value, if “Viewing Month” is Feb-2022" then return the Feb-2022 value etc. - Use that ITE column in your collections setup. ---
**Author:** ![Js\_H](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/js_h/32/41578_2.png) [@Js\_H](https://community.glideapps.com/u/Js_H)\ **Post date:** [April 21, 2022, 2:47am UTC](https://community.glideapps.com/t/how-do-i-separate-out-items-by-month-when-using-collection-component/40962/3 "2022-04-21T02:47:53Z")
> [@ThinhDinh](#): > > s Hi @ThinhDinh! What would be your other advice if I don’t keep that data structure I had created. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [April 21, 2022, 2:56am UTC](https://community.glideapps.com/t/how-do-i-separate-out-items-by-month-when-using-collection-component/40962/4 "2022-04-21T02:56:09Z")
why do you have columns for months??? your data is wrongly structured… keep all entries in rows, not columns… and create logic columns to organize dates: ![Screen Shot 2022-04-20 at 11.02.17 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/a/ea7c913228cd3957467b61bb38b8dbad07dc93b4.png) ![Screen Shot 2022-04-20 at 10.57.36 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/b/7b72a0a0edbd6bb79790005dd709ff38c09b7c4a.png) > **[Personal Time Card DEMO](https://time-card-demo.glideapp.io/dl/ewAiAHQAIgA6ADAALAAiAHMAIgA6ACIAYwBsAGEAcwBzAC0AVABpAG0AZQAgAEMAYQByAGQAIgAsACIAcgAiADoAIgBIAHMAcAB1AEUAcwAzAEgAVABGAEcARQA1AG4ANwAyAHQAZQBKADYAWABRACIALAAiAG4AIgA6ACIAUABlAHIAcwBvAG4AYQBsACAAVABpAG0AZQAgAEMAYQByAGQAIgB9AA==)** > > Track your working hours, sort by week, month, or year. Export as PDF files ---
**Author:** ![Js\_H](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/js_h/32/41578_2.png) [@Js\_H](https://community.glideapps.com/u/Js_H)\ **Post date:** [April 21, 2022, 3:06am UTC](https://community.glideapps.com/t/how-do-i-separate-out-items-by-month-when-using-collection-component/40962/5 "2022-04-21T03:06:33Z")
Hi @Uzo, thank you so much. I’ll try that way as well. ---
**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 22, 2022, 3:07am UTC](https://community.glideapps.com/t/how-do-i-separate-out-items-by-month-when-using-collection-component/40962/6 "2022-04-22T03:07:07Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.