6 Replies Latest reply on May 21, 2017 6:26 AM by Ritesh Bisht

    Creating Rivalry Summaries out of Winner/Runnersup Data

    nitin BHAMBHANI

      Hi, I am new to Tableau and would appreciate help with a simple question.


      I have a list in excel with two columns - winners and runners-up.



      Amélie MauresmoJustine Henin
      Amélie MauresmoJustine Henin
      Ana IvanovicDinara Safina
      Anastasia MyskinaElena Dementieva
      Angelique KerberKarolína Plíšková
      Justine HeninAmélie Mauresmo
      Justine HeninAna Ivanovic


      I can create this view in Tableau easily


      Screen Shot 2017-05-13 at 3.37.34 PM.png


      However, what  i want to do is to create a summary cross tab like this one, essentially counting once all times a pair has met in the finals.

      Screen Shot 2017-05-13 at 3.30.03 PM.png

      This would be even better:          

      Screen Shot 2017-05-13 at 3.30.15 PM.png


      I know this is probably very easy but I just can't figure out how to get there!