3 Replies Latest reply on Aug 20, 2018 7:20 PM by meenu choudhary

    Lookup certain values in a dimension without filtering out the whole dimension.

    Sargam Gupta
      NameItem
      ADeo
      APen
      ACar
      BBike
      BDrum
      BCar
      CWater
      CPillow

       

       

      My crosstab looks like the above table. I want all those Names which bought Car as well as other Items that person bought :

       

      Desired Output -

        

      NameItem
      ADeo
      APen
      ACar
      BBike
      BDrum
      BCar

       

      I also have a show/hide parameter applied on 'Item' dimension, just fyi.

       

      Any help will be much appreciated.