To change the expression label in Pivot Table

[thirumalaivadiv]

Hi Team

I want to change the expression label dynamically in pivot table pls help.

Required output will be if LifePro then Disability claim if Lawson Disability Claim Lawson and if difference Difference resply for other columns as well

Thanks

Thiru

[Mark_Little]

Hi,

In your label you would need to use something like

=If(Field='LifePro', 'Disability claim', IF(...))

But this would only work if you are getting a single value here. Also field would be the field in your data your are comparing

Mark