Dimension with qualifying records.

[bhavvibudagam]

Hi Experts,

Can any one please help me on below requirement.

I have one dimension called STATUS like below.

In this dimension I have to show all the records other than Draft and Failed like status -={'Draft','Failed'}.

Please help me on this.

Thanks in advance.

[YoussefBelloum · Accepted solution]

Hi,

try this:

=Aggr(Only({<STATUS-={'Draft','Failed'}.>}STATUS),STATUS)

or

=if(not match(STATUS,'Draft','Failed'), STATUS)