Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
rileymd88
Contributor III
Contributor III

Top N Product Sales by Country and Month

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

1 Solution

Accepted Solutions
sunny_talwar

How about this:

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

View solution in original post

4 Replies
effinty2112
Master
Master

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

How about this:

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

rileymd88
Contributor III
Contributor III
Author

Hi Andrew,

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

R

effinty2112
Master
Master

Hi Riley,

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

cheers

Andrew