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!