I try to extract only the negative amounts of a dimension in which positive, negative and also 0 amounts are mixed.
Could you please tell me the method to encode.
Thanks in advance.
=if( aggr((sum(SALES))<0),NAME_CLIENT), NAME_CLIENT,'OThers')
Retrieving data ...