Pivot Table Month Grouping ? ? ?

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi All

I basically have 2 data columns, the first is a date in the format dd/mm/yy
and the second are sales values for that day.

My question is this: When I create a Pivot Table from this, is there a way
to show the data grouped by month without having to add extra columns to the
data (e.g. =month(a1) =year(a1))

Many Thanks in Advance

John
 
Add the date field to the row area of the pivot table
Right-click on the Date field button
Choose 'Group and Show Detail' > Group
Select Years and Months
Click OK
 
Back
Top