Use a Column into another pivot

[Anonymous]

Hi all,

I'm looking for a methode or function to get an expression from my first Pivot (CH1) into my other pivot (CH2) , is't possible ?

regards

[Gysbert_Wassenaar]

You can copy and paste the expression or you can put the expression in a variable and use the variable in both pivot tables. What you cannot do is reference cells, rows or columns from one pivot table in another pivot table.

[Anonymous]

yeah, I forgot to write it, but my expression is calculated successive columns of my first pivot, i used column(1) for exemple, so I can not copy only phrase I intend to use.

[Anonymous]

Well,

I did it using a variables.

but, if you have a tips to use a column from another pivot, i'm gonna take it

regards

[Anonymous]

Hi

Please could you provide some steps on how to do this.  I have a Pivot with two calculated columns and I would like to compare the values with data from another table.

Thanks

Matt