Can Multiple Range Pivot Table's field button's caption be changed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi,

When I used Pivot Table to consolidate data from different ranges in
different sheets, the created table will have the field buttons labeled as
"Row" & "Column" instead of the actual names of the row and column, for
example Order ID, Company Name.......

I'm wondering whether there is any way that we can change the field button's
caption from, for example "Columns" to Company Name????

Anyone out there has any ideal of doing so???
Please advice, thanking in advance!!!
 
Back
Top