1 Reply Latest reply on Sep 18, 2018 1:44 PM by Patrick Van Der Hyde

    Dynamic indexing based on week performance and apply the same on month worksheet

    Rohit Ghole

      Hello folks,


      I am measuring performance of a carrier based on indexing and then sorting it and publishing top 5 performer for the week, Based on this dynamic sorting I want to pull in the data for month, WoW, year-to-date and YoY for the same ones,


      Based on the performance in a week, the carriers are bound to be displayed and change in sorting, based on this other worksheets will be updated.


      In Excel, I would have used vlookup and pull in month, WoW and YoY data.


      Not sure how to do it in Tableau.


      I am sorry, I cannot attach the tableau sheet due to confidential data and given time constraint cannot create a temporary one.


      Thank you for your help!