Calculated dimension based on selected values

[jessica_webb]

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

[jessica_webb]

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!