# Monthly bills grouped for quarterly payment - how to show only one quarter row? **URL:** \ **Category:** Ask for Help\ **Created:** [October 24, 2024, 10:45am UTC](https://community.glideapps.com/t/monthly-bills-grouped-for-quarterly-payment-how-to-show-only-one-quarter-row/77291 "2024-10-24T10:45:51Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Matt\_Viner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matt_viner/32/36114_2.png) [@Matt\_Viner](https://community.glideapps.com/u/Matt_Viner)\ **Post date:** [October 24, 2024, 10:45am UTC](https://community.glideapps.com/t/monthly-bills-grouped-for-quarterly-payment-how-to-show-only-one-quarter-row/77291/1 "2024-10-24T10:45:51Z")
My app is a platform where companies report their monthly revenue and are charged a percentage of it, calculated monthly. But the companies receive quarterly invoices. I have setup the month rows, and column for quarter etc. I can calculate the quarter payment no worries. What I can’t work out is how to only show one column per quarter. Because the company reports monthly, each month is a new row. So even if I show the Quarter-Year instead of month, I’m seeing three entries. The monthly entries are a collection which shows each month after that date has passed today, it just opens an edit field (the row is created elsewhere when putting in the company’s projected revenue by month). Adding in projected revenue by quarter isn’t an option - we need to keep monthly. Hoping there’s an easy thing I’m missing… ---
**Author:** ![Matt\_Viner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matt_viner/32/36114_2.png) [@Matt\_Viner](https://community.glideapps.com/u/Matt_Viner)\ **Post date:** [October 24, 2024, 10:55am UTC](https://community.glideapps.com/t/monthly-bills-grouped-for-quarterly-payment-how-to-show-only-one-quarter-row/77291/2 "2024-10-24T10:55:28Z")
Solved it. Pretty embarrassing really: just have a checkbox column for the month at the end of the quarter so Mar, Jun, Sep, Dec are true and then filter collection by this column. ---
**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:** [October 24, 2024, 11:28pm UTC](https://community.glideapps.com/t/monthly-bills-grouped-for-quarterly-payment-how-to-show-only-one-quarter-row/77291/3 "2024-10-24T23:28:09Z")
I feel like you are doing it manually right? Sounds like you need to have a month number in your monthly entry, then add an if-then-else column to return a checkbox when the number is 3, 6, 9 or 12. ---
**Author:** ![Matt\_Viner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matt_viner/32/36114_2.png) [@Matt\_Viner](https://community.glideapps.com/u/Matt_Viner)\ **Post date:** [October 25, 2024, 4:20am UTC](https://community.glideapps.com/t/monthly-bills-grouped-for-quarterly-payment-how-to-show-only-one-quarter-row/77291/4 "2024-10-25T04:20:07Z")
no no, did as you suggest but if then with the month name instead of index. Thanks though, good to validate the approach! ---
**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:** [November 1, 2024, 4:20am UTC](https://community.glideapps.com/t/monthly-bills-grouped-for-quarterly-payment-how-to-show-only-one-quarter-row/77291/5 "2024-11-01T04:20:47Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.