View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Pivot tables and dates

Right-click on the Date field button in the pivot table
Choose Group and Show DetailGroup
Select Years, click OK

Sue wrote:
I am creating a pivot table for a department in the healthcare clinic that I
work for. They want to run a report that shows by year of the number of
people that have gotten labs done in another facility. The Start Date column
is formatted as mm/dd/yy. Is there away that I can group the dates together
by year? All I am able to do is show each individual date. Thanks for your
help. Sue



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html