View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
ArcticWolf ArcticWolf is offline
external usenet poster
 
Posts: 70
Default Pivot Table - "data" part

Hi,

I have three columns (name, location, date of visit) and have put these into
a PT. Name in row
Location in column
Date in data

I need to x-ref people and the date they visited a particular site.

Problem is that the date is asking for sum (or count or average or max
etc..) and all I want to do is display the date. How can I just display the
date for each entry without it trying to find the sum/avg/max etc...

Thanks in advance.

AW