Limit dimension option as Others

[Bhuvi]

Hi all,

I have limited the dimension up to 10 and other values come under others option.

Now, whenever I click on others dimension, I get other values of the dimension, but I don't want to show that.

Is there any solution for this?

Thank you!

[Gabbar]

What do you want to show?
Why not try removing 'Others' from the load editor ?

[anat]

use calculated dim like :

If(Aggr(Rank(sum(sales)), Item) < 10, Item,'Others')