hi , I am trying to get the top 5 people by sales for each year shown over time. I used Index() but maybe was not using it correctly. please help. thank you!
That's a tricky one. I recently came up against this dilemma and solved it with a bump chart:
How To: Using Ranks to Create Bump Charts in Tableau | Sir Viz-a-Lot
Retrieving data ...