Expression Filtering

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I wish to sum sales revenue, for a particular set of accounts, for a singular brand.

So far, I have tried the below, but, I want to increase it to CUST002,003 etc.

Sum(Aggr(If([Account Code]='CUST001', Sum({1<Brand={"Cola"},Year={">2015"}>}[Sales Revenue]])

Is there a better way to achieve this?

Re: Expression Filtering

marcus_sommer — Thu, 18 Aug 2016 13:13:56 GMT

Why not extending your set analysis to this filter, like:

Sum({1<Brand={'Cola'},Year={">2015"}, [Account Code]={'CUST001','CUST002','CUST003'} >} [Sales Revenue])

maybe also with a wildcard:

Sum({1<Brand={'Cola'},Year={">2015"}, [Account Code]={'CUST00*''} >} [Sales Revenue])

and you will rather not need an aggr within your expression (or you should post the complete expression).

- Marcus