how to link tables using set analysis?

[bm59]

Hello,

Sorry for my english....

I have two tables with no link, I would like link them in pivot table.

exemple:

"shop" and "Rack" are my dimension.

sum
 

 
 ({<Mag=P(shop),Ray=P(Rack)>}Obj)

but this expression doesn't work, the dimension was not use in my pivot table, the result is the sum of "Obj" for ALL "shop" and "Rack"...

sum({<Mag={'1'],Ray={'2'})>}Obj) this is ok but juste for Shop 1 and rack 2....

thx

how to select data in a alone table which value of my dimensions in a pivot table?

[erichshiino]

Maybe you have problems with the pivot dimension changing your results.

I included an example using your expression on text objects and it is working fine.

Regards,

Erich