Exclude Value form Dimension

Question

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?

This is not a set analysis sentence.Set analysis have the following fomat {<>} — Distopic, Nov 08 '18 at 13:01

score 1 · Accepted Answer · answered Nov 08 '18 at 13:02

1

This is the solution optimal: =if(aggr(Rank(Count {<Word-={'Among'}>}(WordCounter)),Word)<=70,Word)

answered Nov 08 '18 at 13:02

Distopic

score -1 · Answer 2 · answered Nov 05 '18 at 18:18

-1

Try :

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

answered Nov 05 '18 at 18:18

BrunoMarques

Using set analysis is the best recomended option because using if is bad in time of refresh. – Distopic Nov 08 '18 at 13:00

2 Answers2