Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be like:
SUM({<CAMPAIGN=P([SALES_B CAMPAIGN])> + < CAMPAIGN=P([SALES_C CAMPAIGN])>} SALES)
May be like:
SUM({<CAMPAIGN=P([SALES_B CAMPAIGN])> + < CAMPAIGN=P([SALES_C CAMPAIGN])>} SALES)
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
This?
SUM({<CAMPAIGN=P([SALES_B CAMPAIGN])> + < CAMPAIGN=P([SALES_C CAMPAIGN])> - < CAMPAIGN=P([SALES_D CAMPAIGN])>} SALES)