Filter

[#1]

I have Inline dimension e.g,i used both in [food information] in filter  in Sheets.....i used this filter in two sheet...In one sheet i show in filter

Apple and Mango.........And in second sheet i show all in items  [Food Information] in filter......How can i achieve using same inline dimension.

[Food Information]

load * inline

[

Fruit

Apple

Mango

Graphs

  Orange

]

[mustafaelryah]

Explore more Mr. Hammad

[arulsettu · Accepted solution]

try this for first sheet

in list box->expression  if(match(Fruit,'Apple','Mango'),Fruit)

second sheet display all data in listbox

[#4]

Hi Arul,

By using ur expression I got the below results.

is it possible to show only apple and mango?

Thanks

Sudha

[arulsettu]

in list box istead of selecting filed select expression and use the above code

i got this

[#6]

Hi,

define the expression as a field in the list box
=ValueList('mango','apple')

[#7]

got your point.Thanks for you respsone arul.

[arulsettu]

my code is displays mtaching values from the field.

this one is like giving values in list.