Set Analysis Error

[#1]

Hi All

Getting error in expression.

Job Number and Sales Order Number has 1:1 relation and same no. For ex: If Job No = 1234 then Sales Order No = 1234

I want to link data so that I can get Invoice Amount details at Job No level.

Dimension = Job Number

I tried below expression but this gives error:

sum({<[Sales Order Num]={[Job Number]}>}[Invoice Amount])

Can someone help pl?

[Anonymous]

this should work:

sum({<[Sales Order Num]=P([Job Number])>} [Invoice Amount])

[#3]

I tried above expression but its not working.

Any alternative?

[SunilChauhan]

use this

sum({<[Sales Order Num]={$(=[Job Number])}>}[Invoice Amount])

hope this help