4 Replies Latest reply: Apr 27, 2012 6:32 PM by Federico Levi RSS

    Rank for table

      I have a dimension country.

      I want to know for each country in a table, which is the top product with sum(sales)



      It should look like this:

      Country     Product

      Mexico          A

      England         B

      USA              C

      France           A


      I tried with:



      I tried combining if, rank and aggr but with no luck yet.


      Any ideas?