Exclude items from straight table search

[sambrown]

Hi,

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 [

Food, Stock

Apples, 26

Pears, 45

Cucumbers, 0

Tangerines, 465

Peaches, 35

Melons, 0

Oranges, 478

Lemons, 0

Tomatoes, 47

Yams, 125];

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

[ogster1974 · Accepted solution]

rather than use limitation make the dimension a calcuated one in master items.

something like

if(aggr(sum(Stock), Food)>0, Food, null())

Then exclude nulls from your table and your search should be resitricted as you want.

Regards

Andy

[sambrown]

Thank you so much, now hopefully I can change this thread's title to make more sense!