Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
]
try this for first sheet
in list box->expression if(match(Fruit,'Apple','Mango'),Fruit)
second sheet display all data in listbox
Explore more Mr. Hammad
try this for first sheet
in list box->expression if(match(Fruit,'Apple','Mango'),Fruit)
second sheet display all data in listbox
Hi Arul,
By using ur expression I got the below results.
is it possible to show only apple and mango?
Thanks
Sudha
in list box istead of selecting filed select expression and use the above code
i got this
Hi,
define the expression as a field in the list box
=ValueList('mango','apple')
got your point.Thanks for you respsone arul.
my code is displays mtaching values from the field.
this one is like giving values in list.