1 Reply Latest reply on Sep 18, 2018 1:44 PM by Patrick A 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!

       

      Thanks