Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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