Another Set Analysis issue

[justinasp]

Hi, guys,

I need to sum sales for supply scheme A1 in all branches and A1,A2 schemes in Office. Using IF(..) statement, it would be

sum(if(supp_scheme='A1' or bra_id='OFI', sales))

However it is part of set analysis, so I need to write it in that style. It could be something like

sum({<supp_scheme={'A1'} - {"bra_id='OFI'"}>} sales)

Any ideas would be appreciated,

Justinas

[jagan · Accepted solution]

I hope the following is you are looking for.

sum({<supp_scheme={$(=if(bra_id='OFI', 'A1,A2', 'A1'))}>}sales)

Regards