Pivot table not recognising a field

[Ian_M_Spence]

I have a dataset that includes a date field and I wish to seek totals by year. I have created a field called 'Year' and entered the formula, eg =year(A2), formatted the result as a number with no decimal places and see the years in the Year field. I then wanted to do a pivot table to see the totals of two variables according to year, but in the Pivot table field selection, the field 'Year' is not listed. Why? How can I get it to be listed?

This is using Excel on Mac. I have never had this problem using Excel on PC.

Any suggestions to overcome the problem would be most welcome!

Thanks in anticipation, Ian

[#2]

Hello,

Based on your explanation that you created a new column in your source data to extract the year using =YEAR(A2).

When you create PivotTable forthwith, you should have the Year as one of the Field in your PivotTable taste pane to create report as desired...

Just check the source data again and confirm that the year column created is fine... You can upload a sample picture to verify also.

Cheers

[#3]

@Ian_M_Spence 

In general you don't need such column, you may have totals by year grouping dates by year