Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot table puzzle: "Top 10" for categorical data | Excel Discussion (Misc queries) | |||
Make pivot table with multiple "data" fields in columns not rows? | Excel Discussion (Misc queries) | |||
Pivot Table - Remove "sum of" in data field | Excel Discussion (Misc queries) | |||
Pivot table "Show all data" query | Excel Discussion (Misc queries) | |||
Changing data source in pivot table- "Back" button is disable | Excel Discussion (Misc queries) |