How to summarize Sale data by yearly

Step-by-step:

Ensure your data has a Date column (like Sale Date) and a Sale Amount column.

  1. Select your data → Press Ctrl + T to make it a table (optional but useful).
  1. Go to Insert → Pivot Table.
  1. In the PivotTable Field List:
  • Drag Sale Date to Rows.
  • Drag Sale Amount to Values.

Right-click any date in the row → Click Group → Choose Years (you can also add Months if you want).

Done — you now have a yearly summary of sales!

Leave a Reply

Your email address will not be published. Required fields are marked *