This content has been marked as final. Show 2 replies
The obvious general answer is that the value that is being used to filter the column has no match. Try doing this:
1) On the column that will receive the dashboard prompt presentation variable, click on the fx button.
2) Apply the TRIMBOTH function and for the char, use a space (single quote, space, single quote).
3) Click the filter button on this modified column and set it equal to the PV.
Sometimes the column contains a leading or trailing space in it. No problem if you just display all values and hard to tell why filtering for a value known to be in the table results in "no results." Often the extra space is the culprit. Try it.