View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
muddan madhu muddan madhu is offline
external usenet poster
 
Posts: 747
Default Change the name of the Data field in a Pivot Table

select the sum of actual | right click | field setting | change name
field as u want | ok



On Oct 2, 7:04*pm, John wrote:
Hi,

I would like to amend the Field Heading in a pivot. *Currently they read
Sum Of Actual
Sum Of Forecast

How can i drop the "Sum of" please?

Thanks
John