Show only ticket/task where task number is the highest

[R_B_]

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!

[Marc_Dillon · Accepted solution]

Yes, use a Slice, along with MAXROW

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