3 Replies Latest reply on Feb 26, 2015 3:07 PM by Oleg Lychkovski

    Ranking Annual Equivalents

    Greg Blackshields

      Hi all

       

      I am trying to use the Ranking function to allow me to choose Top 10 sellers by value YTD 2015 and their equivalent 2014 number for the same time period but cannot seem to be able to get to the answer as when I put in both years Tableau is ranking by sub total for the seller.

       

       

      In essence all I need is to choose whatever month in 2015, get the Top 10 and then show what thier value was in 2014 to allow me tio do a YoY calc.

       

      Any ideas?

       

      Cheers

       

      Greg