Exists function for charts?

[danielact]

Is there a comparable function that can be used in charts?

I have a data set which I want to filter using a dummy field for various reasons. I have 9 fields, but let's use one to start. Let's call it User. So I created another table with the field called User2 from the original set.

Here's my dimension and expression:

Dimension: =pick(match(num(aggr(rank(sum({1}Loss),4,1),Year_Sequence)),

1000,500,200,100,40,20,10,1),'1/10','1/20','1/50','1/100','1/250','1/500','1/1000','1/10000',)

Expression: sum({1}Loss)

So I want to be able to filter the data using the User2 field, not the original User field. I think an exists function would be good for this, but that's only for scripts, not objects, right?

Any ideas on how to do this? Please don't try and convince me to do it with the original field, I have reasons for not wanting to - it's just complicated to explain why.

[jonathandienst · Accepted solution]

Hi

I think that you could use the P() function, like this:

Sum({1<User1 = P(User2)>} Loss)

Regards

Jonathan

[danielact]

Worked perfectly! Thanks!