display top n in pivot table

[#1]

Good evening friends

I am facing  a problem and I need your help

I try to display the first 10 sales per country in a Pivot table

so I added this expression in dimensions

and as a result I have

as you can see  for 2010 it gives a result USA-> France-> germany   and the logical order and it

  USA-> France-> UK why?

Thank you for your answers

[Gysbert_Wassenaar]

Your expression aggregates only per country so you get the ranking of countries without considering the year dimension (which is not in the aggr definition). That's why you see the same three countries listed for each year.