# Extract (only) the first row of a given month

**URL:** <https://community.glideapps.com/t/extract-only-the-first-row-of-a-given-month/74485>\
**Category:** Ask for Help\
**Created:** [June 30, 2024, 3:28am UTC](https://community.glideapps.com/t/extract-only-the-first-row-of-a-given-month/74485 "2024-06-30T03:28:21Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ryan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ryan/32/15941_2.png) [@Ryan](https://community.glideapps.com/u/Ryan)\
**Post date:** [June 30, 2024, 3:28am UTC](https://community.glideapps.com/t/extract-only-the-first-row-of-a-given-month/74485/1 "2024-06-30T03:28:21Z")

</div>

Hi team,

My table format is something like  
ROW ID, Month + Year, CategoryID, Amount  
1, 01-2024, 1, 10  
2, 01-2024, 2, 20  
3, 01-2024, 1, 15  
4, 02-2024, 1, 20

And I’m looking for a way to extract the first amount value per Month+Year&CategoryID combination, i.e.:  
ROW ID, Month + Year, CategoryID, Amount, First Amount  
1, 01-2024, 1, 10, 10  
2, 01-2024, 2, 20, 20  
3, 01-2024, 1, 15, 10  
4, 02-2024, 1, 20, 20

And to be more precise, as this table might get a bit messy, I would like to extract the relevant RowID (as the key is unique, unlike the ‘amount’):  
ROW ID, Month + Year, CategoryID, Amount, First AmountRowID  
1, 01-2024, 1, 10, 1  
2, 01-2024, 2, 20, 2  
3, 01-2024, 1, 15, 1  
4, 02-2024, 1, 20, 4

Happy to hear your thoughts, thanks.

---

<div class="post-metadata">

**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:** [June 30, 2024, 3:35am UTC](https://community.glideapps.com/t/extract-only-the-first-row-of-a-given-month/74485/2 "2024-06-30T03:35:59Z")

</div>

- Create a Query column that targets the table and apply the following filters:  
– Month-year is This row-\>Month-year  
– Category is This row-\>Category
- Use a Single Value column to select the first amount (or RowID) from the query.