Slice filter

[Uribe]

Hello Experts!

I need to make a slice that shows only the rows marked in green, that is the latest date for each period, for each name.

I've been trying and trying but can't make it.

Please help me with the filter expression 🙏

@Steve 

[Marc_Dillon]

Have you tried MAXROW ?

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

[Uribe]

I thought about it, but I can't figure out how to get the max date for each period and each name.

[Marc_Dillon]

You would do:

[key-column] = MAXROW( thistable , date , AND( name=name,period=period) )

[Uribe]

It returns only one row 😕