The source data for my pivot table has a bunch of fields of which I'm only using a few in my actual pivot table. Two of the fields I do not want to display in my pivot table are rates and fees; however, I want those rate/fee columns to appear as a % and $ respectively upon double clicking for the output to show the full detail of the fields I am showing. Can this be done? I'm using Excel 2003 and I'm not familiar with how to write code. Thanks!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Control How Pivot Table Output is Formatted
- Thread starter lsofia
- Start date
Similar threads
- Question
