I’m trying to create a row filter expression for a slice with the following criteria:
AND([Procedure]=“Task Analysis”, [Status]=“Current”, [Step #]= ??? ))
It’s the third criterion that I’m struggling with, because I need the list of records with the lowest number (that’s also “current” and a “task analysis” obviously), and it can be any number from 1-15. I’ve played around with MINROW and LIST() but nothing has worked so far. Thanks!