1 Reply Latest reply on Jul 1, 2016 12:17 AM by Tharashasank Davuluru

    Apply certain IDs extrancted from a filter over the whole datasource

    Aditya Panidepu

      Hello All,

      I am New to tableu, tried searching solution for my problem but couldn't fnd.Hence, posting it. If there is already a solution to this question please do provide me the link

      I have a database in the below format

         

      IDNth TransactionArticle Bought
      11Pen
      12Ball
      13Paper
      14Pen
      15Pen
      16Paper
      21Ball
      22Paper
      23Pen
      24Pen
      25Paper
      31Pen
      32Paper
      33Ball

       

      I would like to get the set of IDs who have bought 'Pen' in their first purchase i.e. Nth transaction = 1 and would like to use that to find out what did they buy in the second transaction

      Tried using Sets..but did not work

      Kindly help

       

      Regards,

      Aditya Panidepu