Change values in Pivot Table

[Shay A]

Hi,
If I would like a to create a code to create a code to replace one measure with another and vice versa, will a simple recording do the trick? I want this code for a specific pivot on my workbook and not to the other pivot tables.

TY,
Shay

 

[chirayu]

Whe you say measure? Do you mean column, row, filter or values?

Either way since its only 1 specific PivotTable you can record it and chage the bits you need to suit by using and IF formula with a Variable

 

[Shay A]

I mean values of course, sorry. Ok I will try to recrord it. Not sure I would need a variable though.

 

[Shay A]

Or an If statement