How do I separate out items by month (when using COLLECTION component)

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!



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.

2 Likes

Hi @ThinhDinh! What would be your other advice if I don’t keep that data structure I had created.

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:

1 Like

Hi @Uzo, thank you so much. I’ll try that way as well.

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