0 Replies Latest reply on Oct 15, 2018 2:13 AM by Madhu k

    Merging two worksheets based on calculated filed

    Madhu k

      Hello Everyone,

       

      i am trying to merge two worksheets in tableau. Need help

       

      sheet1: created a table and ranked based on increase in sales

      sheet2; created a table and ranked based on decrease in sales

       

      now, i need to match(Basically, like excel vlookup, rank 1 from sheet one should match with rank 1 of sheet 2 with all other columns) ranks. I tried using Custom SQL and blending on calculated field but solution is not there. Please help.