Exclude Value form Dimension

[pguereca]

I have this set analysis sentence:

=if(aggr(Rank(Count(WordCounter)),Word)<=70,Word)

I have a request to remove "Among" from the Word data.

Any suggestion?

[lironbaram]

hi

try this

=if(aggr(Rank(Count({<Word-={'Among'}>}WordCounter)),Word)<=70,Word)

or this

=if(aggr({<Word-={'Among'}>}Rank(Count(WordCounter)),Word)<=70,Word)