question about set analysis

Hi,

I am using the set analysis to implement my task and I have found out some unlogical features.

My task is as follows: on the one hand a user must be able to select the needed brands in a list box and make some analysis based on these brands, on the other hand a user must always see TOP-10 brands on the screen regardless of his/her choice in the list box.

I decided that set analysis is the best tool to solve the task. In order to calculate top 10 brands I use the expression:

Re: question about set analysis

I prefer a set expression to Dimension Limits. But if I change my if statement to the suggested expression: Sum({$<Brands={"=rank(sum({<Brands=>}Budget)<11)"}>} [Budget] ) then TOP-10 brands are not distinguished, and the budget of all other brands is calculated too. Please see the file attached.