Forum Discussion
Text Filter Facing conundrum!!
I am using Text Filter Visual to filter out values in a table and the SELECTEDVALUE function shows the output based on it. The input is name of a person in the text filter, and if the name is found ...
John is a separate row entry under the column 'name' in the 'Table 1'. Similarly, Johnson and Johny are also separate entries.
I want that if I enter John in Text filter, I get only John. Right now, I am getting Blank, as John is not treated as distinct entries by SELECTEDVALUE function.
But when I enter Johnson or Johny, I get them respectivaly as the output as they are treated as Distinct entries.
