18 Replies Latest reply: Jun 19, 2018 3:43 PM by Vishwarath Nagaraju RSS

    Calculated Dimension using ONLY function?

    Vidya Sagar Polu

      Hi,

       

      I am trying to achieve the following:

       

      Sample Data:

      LocationSublocationPart
      AA112345
      BB123456
      BB212456
      CC114678
      CC218992
      DD118320
      DD210302
      ABAB110320
      ACAB213920
      ADAB310401

       

      My Dimensions are:

       

      1. Location

      2. Sublocation

       

      However, I do not want to show all Locations as my dimension. I would like to use ONLY function with set analysis ?

       

      I have tried the following but it does not seem to work:

       

      Only ({<{Location-={'AB','AC','AD'}>}Location}

       

      Basically i do not want to show locations with AB, AC, AD. Since this is a sample data set, i am only showing few location. However, i have quite a few locations that i want to show and exclude some. That is why i am going with not contain in set analysis.

       

      Can someone help me on this?

       

      I have attached the sample file.

       

      Thanks,
      Vidya