have a look at the attach examples
it uses aggr function to disregard brand selection for the ranking function
Sample (1).qvw 160.0 K
First of all thank you for taking the time to try and help me with this.
Your example works in the sense that it maintains the ranking when I select a Brand or sort on a Brand, however it seems to be ranking the country within the brand as opposed to the brand within the country.
For example company X is getting rank 1 in the country it is selling the most etc. What I am trying to show is the rank of company X against the other companies in a given country.