This content has been marked as final. Show 4 replies
I want to create a field or a front end expression to filter rows in Status field.
The user should have 2 values to choose- Top, All.
When All is selected, show all products. If Top is selected show only products with status Yes.
LOAD * INLINE [
I created this filter but it is not working
if(Status = 'YES' or Status = 'NO','All',
if(Status = 'YES','Top'))