Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
And as list box field expression:
=Aggr( Only({1<FactKey={"R1"},Cod = P({1<FactKey={"R2"}>} Cod)>} Cod), Cod)
May be remove 1 within the P()
=Sum({$<FactKey={"R1"}, Cod = P({<FactKey={"R2"}>} Cod)>} Value)
Try the intersection operator *
=sum( {$<FactKey={"R1"},Cod *= P({1<FactKey={"R2"}>} Cod)>} Value )
And as list box field expression:
=Aggr( Only({1<FactKey={"R1"},Cod = P({1<FactKey={"R2"}>} Cod)>} Cod), Cod)
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.
ok