Dimensions Do Not Work As Expected When Graph Has 'P' Possible Data

[Anonymous]

i,

I have a graph using expressions with the 'P' function but when I try to filter one of the dimensions it does not work.

I'll send a small application in attach that if you select 1 value in the LOV should filter and show in the graph only the line with this value.

Additionally i also intended that only the available values (using the same "P" function) in the LOV? it's possible ?

Thank you in advance for your help.

Ricardo

[sunny_talwar]

May be remove 1 within the P()

=Sum({$<FactKey={"R1"}, Cod = P({<FactKey={"R2"}>} Cod)>} Value)

[swuehl]

Try the intersection operator *

=sum( {$<FactKey={"R1"},Cod *= P({1<FactKey={"R2"}>} Cod)>} Value )

[swuehl · Accepted solution]

And as list box field expression:

=Aggr( Only({1<FactKey={"R1"},Cod = P({1<FactKey={"R2"}>} Cod)>} Cod), Cod)

[Anonymous]

Both (3) the answers are correct, but Stefan Wühl as answered the 2 I give him the points of the correct answer.

Thank you very much.

[sunny_talwar]

ok