8 Replies Latest reply: Aug 17, 2018 12:31 PM by Vishwarath Nagaraju RSS

    Rankings

    Wesley Tam

      Hello,

       

      I am currently trying to create a table with the top 3 ranking domains as a dimension in my straight table.

       

      My tables currently look like this:

      Ranking Table

      KeywordDomainRank
      Keyword ADomain A1
      Keyword A
      Domain B
      2
      Keyword A
      Domain C
      3
      Keyword A
      Domain D
      4
      Keyword A
      Domain E
      5
      Keyword BDomain B1
      Keyword BDomain D2
      Keyword BDomain A3

       

      Keyword Metric Table

      KeywordTrafficCost Per Click
      Keyword A50,000$45
      Keyword B30,000$7
      Keyword C15,000$18
      Keyword D18,000$12

       

      The desired output should be:

      KeywordTrafficCost Per Click#1 Ranking#2 Ranking#3 Ranking
      Keyword A50,000$45Domain ADomain BDomain C
      Keyword B30,000$7Domain BDomain DDomain A
      Keyword C15,000$18Domain CDomain BDomain E
      Keyword D18,000$12Domain DDomain EDomain A

       

      The #1,#2,& #3 ranking column refers back to the rank shown in the ranking table above. Is it possible to show this in a straight table using calculated dimensions?