allocating sum according to calculated share

[dafnis14]

Hi,

I need to allocate products revenue to a certain product (service).

My data:

Only products that are marked with the flag "In Report?" should be taken into account.

The service product is marked with the flag "Service?".

I fail to achieve it with Set Analysis. Maybe it's not feasible?

I used the expression:

sum({<Service?={1}>}Revenue)
*
(
sum({<[In Report?]={1}>} Revenue)
/
sum( TOTAL{<[In Report?]={1}>} Revenue)
)

Attached is a sample model  I built.

Thanks in advance!

[jochem_zw · Accepted solution]

please try

sum(total {<[Product Name]=,Service?={1}>}Revenue)
*
(
sum({<[In Report?]={1}>} Revenue)
/
sum( TOTAL{<[In Report?]={1}>} Revenue)
)

[dafnis14]

Brilliant!

Thanks!