Hi there. I have a very large database where many cells contain multiple values, e.g. "NA, EALA, APAC" but in filter and calculation i need to have "NA" "EALA" and "APAC" as separate items, and any cell containing "NA", like "NA, EALA" or "NA, APAC", will be considered in calculation for "NA". I was wondering if this is possible, and if yes, how to realize it. Thanks a lot.
[new added] for the filter, we have the original data as follows (the fourth row has multiple values)
|Health; Health Plans; Border Management||60|
Could we show in filter this way?
A calculation something like:
contains([Your Dimension], "NA")
set to true on the filter. You could also use a filter to fill/change the NA part