This content has been marked as final. Show 4 replies
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))