Show N greatest values of grouped records


#1

Let’s say I have a table with cars: model, make, year, prize. Cars are sold on different dealer’s and I have a table showing all data, grouped by the dealer.

I know that I can make a filter which only shows in my table cars which are more expensive than a set value. But is there a way to create a filter to show only for example three most expensive cars?


#2

Anyone have any ideas? Or is this simply not possible atm?