RobFJ wrote:
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





Look at "Create your own formula in a PivotTable or PivotChart report" in the
help file.