Select dimension in set analysis

xoylhat2 — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Select dimension in set analysis

sunny_talwar — Thu, 12 Apr 2018 15:47:49 GMT

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))