Top N Product Sales by Country and Month

[rileymd88]

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

[effinty2112]

Hi Riley,

                    You can hide dimension columns you don't want to see.

Go to the Presentation tab and select Hide Column for the dimensions you want to be invisible.

cheers

Andrew

[sunny_talwar · Accepted solution]

How about this:

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

[rileymd88]

Hi Andrew,

If I do this then I the country will repeat itself for every unique Country, Month and Product ID combination.

R

[effinty2112]

Hi Riley,

               Yeah ... I didn't think it through .

cheers

Andrew