Show only ticket/task where task number is the highest

Hi,

I’m trying to filter data based on the highest task number of a ticket.

For example:

ticket task info

12 1 test

12 2 …

13 1 test2

Than I only want to see the rows 12/2 and 13/3 in my view. because those are the ticket/task combinations with the highest task values.

Can somebody pinpoint me in the right direction? I’m struggling atm.

I prefer to do this as row filter for a slice.

Thanks!

Yes, use a Slice, along with MAXROW

https://help.appsheet.com/en/articles/2357310-maxrow

1 Like