For multiple field selections

[d_koti24]

Hi folks,

PFA..

I am able to select only one cat at a time ,for comparasion purpose i want to select muliple cat's at a time in same chart?

here i have a field CAT

i want select multiple options at a time how to achieve this

i.e: i want select 'A' ,"B' at time in same  chart to get

[sunny_talwar · Accepted solution]

look at the attached:

[d_koti24]

Thanks Sunny..

Can you please explain me that exp?

=SubStringCount(Concat(DISTINCT CAT), 'A') = 1

[sunny_talwar]

Concat(DISTINCT CAT) creates a concatenated list of CAT based on your selection. and then SubStringCount Counts all the Occurrences of A in it. If it equals 1, the expressions is showed, else not.