View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mattlynn via OfficeKB.com Mattlynn via OfficeKB.com is offline
external usenet poster
 
Posts: 140
Default Pivot Table Data Formatting.

Hi there
On a Pivot tabe layout, you have a section for Data, Page, Column & row.
When i build a pivot table , the numbers in the "data" section of the pivot
always default to a "Count" format.
Can we change the default to be sum ?
Thanks very much
Matt

--
Matt Lynn

Message posted via http://www.officekb.com