4 Replies Latest reply on Oct 20, 2016 11:45 PM by BABOUCARR TOURAY

    How to show year by year increase in Rankings

    BABOUCARR TOURAY

      Hello Everyone,

       

      I'll like to create three tables. One showing only students whose rankings have gotten better year by year, for eg. Mike. Another showing students whose rankings have dropped year by year for eg. Andrew. And the last table showing students whose rankings have stayed flat. eg. Lucy. Dragging "Student" in Rows, "Year" in Columns, and "Rank" in Text shows me all the students with their respective ranks for each year. However, I want to see how they are performing in separate tables. An example of the data set from excel is below. Thank you all for the support!

       

          

      yearrankStudent
      20131Andrew
      20142Andrew
      20153Andrew
      20168Andrew
      20137Mike
      20144Mike
      20153Mike
      20161Mike
      20135Lucy
      20145Lucy
      20155Lucy
      20165Lucy
      201313Jane
      20145Jane
      20159Jane
      20162Jane

       

      Regards,

       

      Baboucarr