Set analysis help

[#1]

Hi

I wrote the set to calculate the amount as

sum({<Company={A},Branch={'X','Y','Z'}>}Amount)+sum({<Company={B},Branch={'X','W','A'}>}Amount)

the problem is when i select the company A, then the amount should show

only for the Company A, but here the value shows both A and B irrespective of the Company selections.

Could anyone help me.

thanks in advance.

[CELAMBARASAN]

Hi,

     Use the expression with $

     sum({$<Company={A},Branch={'X','Y','Z'}>}Amount)+sum({$<Company={B},Branch={'X','W','A'}>}Amount)

Hope it helps

Celambarasan

[kuba_michalik · Accepted solution]

$ is entirely optional here.

Try this:

sum({<Company={A}*P(Company),Branch={'X','Y','Z'}>}Amount)+sum({<Company={B}*P(Company),Branch={'X','W','A'}>}Amount)

Be careful, though - if you select Company C (if there is one), nothing will get shown.

[#4]

Thank you very much....