View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RobFJ[_2_] RobFJ[_2_] is offline
external usenet poster
 
Posts: 3
Default Pivot Tables and Groupings

I've got a pivot table where one of the fields I'm analysing is people's
birthdays.

At the moment the table is giving a unique row instance based on day month
and year

Is there a way I can make the pivot table group only on year.


Tx