4 Replies Latest reply: Aug 31, 2016 6:08 AM by Andrew Walker RSS

    Top N Product Sales by Country and Month

    Riley MacDonald

      Hi All,

       

      I am trying to look at my sales data overall across different countries, but restricted to the top 50 selling products per country and month. I am able to get this view in a straight table, however only when I bring in all dimensions (Country, Month and Product ID). Is there anyway to get this same number in a straight table but only using the dimension Country?

       

      Here is the formula I am using at the moment:

      =If(Rank(Aggr(Sum(Sales), Country, [Month], [Product ID]), 1) <=50, Sum(Sales))

       

      Thanks,

      R