View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Siew-Ming Siew-Ming is offline
external usenet poster
 
Posts: 2
Default Pivot table field settings

Hi,

Instead of displaying the sum, count or average of the data, I would like
the exact data to be displayed. Is it possible? The main reason is the data
is in text format like SocialScience456, LanguageArt123 and etc. The row is
in TeacherName and the column is in Period#.


Thanks,
Siew-Ming