Hi,

I have a pivot table I am using for a report. I would like to format several variables differently (ie spend would be in accounting format, sales as general, etc). I know you can change the format by right clicking on the variable, but I would like a more permanent solution so that if I remove the variable from the "Values" list, it will still have the designated format when I bring it back in.

Thanks!