Cube View - Top 10 result view.

A cubeview is not the best for this sort of requirement. You could, in theory, write a custom Member List that does all calculations and returns the ordered list of members to display, but it feels overkill and it's likely to contain mistakes.

I would suggest the following instead:

1. Create your CV to retrieve data for all locations
2. Create a Data Adapter (in Workspaces ) of type Cube View MD, pointed to that Cube View
3. Add that adapter to a component like Report, BiViewer, or Pivot Grid
4. Use filters in those components to retrieve only the data you need. Example for BiViewer using a Grid widget:
   
   
   
   

    

A similar alternative is to write a Dashboard DataSet rule that will do the filtering, and again wire it to a Report or BiViewer component through a Data Adapter (of type Method/Business Rule). That's fairly easy if you're familiar with that sort of thing (there are examples on the blog), but if you don't want to write code, the suggestion above is probably the best approach.