Pivot Tabel - Group

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello,
when i group dates by months from different years in a pivot table, excel
returns:
january, february, march,..., december but does not make a difference
between 2003, 2004. how can i obtain jan-03, feb-03,..., dec-03,
jan-04,...aug-04 ?
thank you kindly for your help !
andy
 
Group the dates by Years and Months. All the 2003 months will be listed,
then all the 2004 months.

Or, add a new column (e.g. YrMth) in the source data table, and use a
formula to calculate the year and month. For example:

=YEAR(A2)&"-"&TEXT(MONTH(A2),"00")

Copy the formula down to the last row of data.
Refresh the pivot table, and add the new field.
 
Back
Top