Select dimension in set analysis

[xoylhat2]

Hi, I have a doubt:

For example, if I have two tables (Tabla1,Tabla2) and I want a pivot table with 2 dimensions, and a value expression like that:

I want the Campo4 value where Campo2=Campo3. I can get this with aggr expression:

=Sum(Aggr(if(Campo2=Campo3,Sum(Campo4),0),Campo1,Campo2,Campo3))

But my duobt is: can I get the same result only with set analysis?

Thanks!

[sunny_talwar]

I don't think this will work in set analysis... because the way the data is structured, you will have to use if statement... you can try this though

=Sum(If(Campo2=Campo3, Campo4))