Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I feel like this should be relatively straightforward, but my brain is not working today!
In my chart, I have a calculated dimension as I only want to show certain values from my field 'Fruit'.
=MATCH(Fruit,'Apples','Pears','Grapes')
That works fine.
But, I have also created a listbox with an expression, to show 5 out of the 20 possible fruits:
FRUIT
Oranges
Lemons
Nectarines
Kiwis
Passion fruit
In my chart, I would like Apples, Pears and Grapes to always show. But if any of the fruits in the listbox are selected, they should also show on the chart.
I was going down the 'get field selections' route, but haven't come up with a working solution yet.
Am I on the right track? Does anyone have any suggestions?
Many thanks,
Jess
Sorry Sunny - no surprises, it's me not getting something!
I saw your expression and copied it straight into my calculated dimension...
Am now using it in the expression as you intended, and it works perfectly!
Problem solved, thank you so, so much!