1 Reply Latest reply on Nov 15, 2013 7:19 AM by Alex Kerin

    Filter & Calculation - Multiple values in one cell

    Tara Carter

      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)

       

      IndustriesDownloads
      Health10
      Health Plans20
      Border Management30
      Health; Health Plans; Border Management60

       

      Could we show in filter this way?

       

      IndustriesDownloads
      Health70
      Health Plans80
      Border Management90

       

      Thanks,

      Tara