12 Replies Latest reply on Jan 11, 2017 6:37 PM by Shinichiro Murakami

    Super Urgent: Top N with data blending

    ra.ka

      Hello All, I have this an urgent requirement. I have two data sources. And need to create a Top N viz. Here is the data and out put I am trying to create. Please help. I am using Tableau Desktop 9.3

       

      Data Source 1
      Sub-CategoryCategory
      1A
      2A
      3A
      4B
      5B
      6C
      7C
      8C
      9D
      10D

       

      Data Source 2
      TypeZoneSub-Category
      ABCx1
      ABCy2
      ABCy3
      ABCy4
      ABCy5
      ABCy5
      ABCx5
      ABCx6
      ABCx7
      ABCx7
      ABCx8
      ABCx8
      ABCx8
      ABCy8
      ABCy9
      ABCy10

       

      Tableau Out put
      RankCategoryXYTotal
      1C617
      2B134
      3A123
      4D22

       

       

      I hope some one could help me with it and Thank you in advance.

       

      Srini