title: Top 10 for each Country on Business Objects Webi
body: <p>I am basically trying to get the top 10 claims by order of fee for all countries. The ranking is simple to do and i already have the rank built.</p>
  
  <p><code>=Rank([Estimated Loss Amount Home Currency];([Claim ID]);Top)</code></p>
  
  <p>But how do i apply that so it does the top 10 for each country? 
  At the moment i have it set up with a break on the country so it ranks the claims within each country. So for example Australia has 21 claims showing (which is all of them and ranks them 1 - 21). When I apply my rank variable as a filter for the top 10, it does it on my whole data set not each country so i end up with top 10 in just Australia and lose the rest of the countries. </p>
  
  <p>I have recreated it in SQL which is easy to do, just cant fathom the logic round it in Webi. </p>
  
  <p>Thank you. </p>