Expression Filtering

[Anonymous]

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?

[marcus_sommer · Accepted solution]

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