Help

Re: Grouping with TOP 1

510 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Jakub_Serafin
4 - Data Explorer
4 - Data Explorer

Hello!

I want to make view in with I’m grouping my items by some categories, but also i want to show only first record in each of those groups. Is there any way to make it that way?

Best regards

3 Replies 3

Hi @Jakub_Serafin,

Welcome to Airtable Community!

You can use the filter option in addition to the grouping option.

BR,
Mo

I know that. But i cannot Find opcjom to filtering based on position in query. Only filters presented on screenshot are available ![Screenshot 2020-04-05 at 09.17.56|647x500](upload://p5bjxygUtfmbiB9JAb3Lrk9RrAZ.png)

Hi,

There was no screenshot in the reply.

Yes, there is no direct way to do so. However, when you say the first record in each group’s there must be a certain criteria for that record, correct?

You can easily do so if you add a field with a 1 or something and filter on this field.