If I have a table with a column of values, some duplicated, I occasionally want to filter the table to a specific value, and I’m currently doing this through setting a Single Select control which is populated based on the unique list of values from the column I’m interested in filtering by.
This works great.
However, sometimes I want to see the whole table… and it seems I’m currently restricted to just selecting one of the values via the control. I tried to add a “*” option to the list, but that didn’t seem to work. I also tried to play with the “Blank” value to have it filter differently (i.e. show me all if the value is Blank), but this didn’t seem to work.
What would I use here as a selectable value to show my whole table again?