Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
look at the attached:
look at the attached:
Thanks Sunny..
Can you please explain me that exp?
=SubStringCount(Concat(DISTINCT CAT), 'A') = 1
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.