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?

       

      Regards

       

      Federico