Set analysis with p()

[justalkak]

Hi,

I have the following case:

User_ID              User_ID_2                  Value

A                             A                                        1

-                               A                                       1

-                             A                                          1

I need to be able to sum(Value) and get result = 3 when a user filters User_ID = A. No option to change data model.

I remember doing similar thing with sth like sum({<User_ID = P({1}User_ID_2)>} Value), but I must be doing sth's wrong because it doesn't work or I am totally thinking this wrong..

Can you please advise how to get the result?

Thanks

[vincent_ardiet_ · Accepted solution]

Hi,
Something like this should do the trick: sum({<User_ID,User_ID_2=p(User_ID)>}Value)

[Aurelien_Martinez]

Hi,

May be Sum({<User_ID_2=P(User_ID), User_ID=>} Value)