topic Set analysis with p() in App Development

Set analysis with p()

justalkak — Fri, 29 Sep 2023 08:00:37 GMT

Hi,

I have the following case:

User_ID User_ID_2 Value

A 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

Re: Set analysis with p()

vincent_ardiet_ — Fri, 29 Sep 2023 09:30:33 GMT

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

Re: Set analysis with p()

Aurelien_Martinez — Fri, 29 Sep 2023 09:33:17 GMT

Hi,

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