Set Analysis with OR in P function

[hugmarcel]

Hi

I want to calculate the sum of sales for all compaigns (main dimension) which are part

of either the sales-b campaigns or the sales-c campaigns (sub dimensions).

How can it be done? Something like

SUM({<CAMPAIGN=P([SALES_B CAMPAIGN]) OR CAMPAIGN=P([SALES_C CAMPAIGN])<} SALES)

does not work.

Thank you!

Marcel

[tresesco · Accepted solution]

May be like:

SUM({<CAMPAIGN=P([SALES_B CAMPAIGN])> + < CAMPAIGN=P([SALES_C CAMPAIGN])>} SALES)

[hugmarcel]

Thank you, that's fine!

What is the correct formula if I want to have all campaigns which are

in ( [SALES_B CAMPAIGN] OR [SALES_C CAMPAIGN] ) but NOT in [SALES_D CAMPAIGN]

Thank you! Marcel

[tresesco]

This?

SUM({<CAMPAIGN=P([SALES_B CAMPAIGN])> + < CAMPAIGN=P([SALES_C CAMPAIGN])> - < CAMPAIGN=P([SALES_D CAMPAIGN])>} SALES)