title: Pivot table group by year
body: <p>I need to create a new calculated column on my pivot table: year.</p>
  
  <p>I know it's possible to put the date into the lines field and manually group from there and it will show up, however my data is too big and I get a run-time error, so I would like to try creating this column using the option of “Calculated Field” but how can I get a year if it only allows me to do simple math (such as multiplication).</p>
  
  <p><a href="https://i.stack.imgur.com/GDbhb.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/GDbhb.png" alt="enter image description here"></a></p>
  
  <p>PS. my excel is in Portuguese as the image shows, but what I need is for a new field YEAR to show up.</p>
  
  <p>EDIT:
  So my endgame looks something like this, I need to create the column Years, I can't do the way I'm used to because of how many lines there are.</p>
  
  <p><a href="https://i.stack.imgur.com/paxzP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/paxzP.png" alt="enter image description here"></a></p>