Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have to format a pivot table column by testing the value of the field; I'd like to use an easy way to refer to it, since it has a complex formula to calculate its value and I delike to repeat it in the format formula.
I know it's possible to refer the fields value by using the header lable ([]), but it has the inconvenience that it goes wrong if I change the header lable without remembering about the format formula.
Is the something which easy refers to the current field value?
Thanks.
N.
Unfortunately not.