I thought this would be an easy thing to find out about, but I can't find anything!
Just a simple example to work with here.
LOAD * Inline [
I create a straight table as a visualisation with 'Food' as a dimension and 'Stock' as a measure and set the limitation of "Stock > 0" so my resulting table will not have Cucumbers, Lemons and Melons. I've taken out Others.
However, when I go to the search magnifying glass at the top of the table. The three items which I have asked to be hidden are still showing in the drop down box. So I can select Melons, but the resulting table will be blank.
My question is, is there a way I can hide things from the search function, like I have with the table itself?
Message was edited by: Samuel Brown
Changed title to make more sense