Current selection not working with set analysis

[Deepak13]

Hello All

I have below expression in my pivot table

=(sum({$<Source={'X'}>}Cost)-sum({$<Source={'Y'}>}Cost))/1000.

the pivot table with above expression is not responding to my current selection. Please help

regards

[jonathandienst]

Do you mean its not responding to a selection of the Source field? Thats because the expression sets the value to be used. Or perhaps you mean other selections as well - in which case the problem probably arises from the data model. 

[Deepak13]

I have 3 pivot tables 

table1 has following expression

sum({$<Source={'X'}>}Cost)/1000

table2 has following expression

sum({$<Source={'Y'}>}Cost)/1000

And the 3rd table is basically the subtraction of the above 2 tables

=(sum({$<Source={'X'}>}Cost)-sum({$<Source={'Y'}>}Cost))/1000

the first 2 are responding to the current selection but not the 3rd .

[Deepak13 · Accepted solution]

I checked the expression for first 2 tables its was simply sum(cost). 

apologies for the confusion, i assumed that filtering is done in set analysis for the first 2 tables, rather it was done using calculated dimension.

for the 3rd table i simply removed the $ sign from the expression and its now filtering records according to the current selection.

Regards