Pivot Table

K

Kim

Hi,
How do I have the date format like Dec-04 in pivot table
(instead of 12/2/2004)? specially in the Row section.

Thanks,
Kim
 
D

Debra Dalgleish

You can group the dates in the pivot table --

Right-click on the Date field button
Choose Group and Show Detail > Group
Select Year and Month
Click OK

Or, create a column in the source table in which you calculate the year
and month of the date. For example, with the first date in cell A2,
enter the following formula in cell B2: =TEXT(A2,"yyyy mm")

Or calculate each date to the first of the month:
=DATE(YEAR(A2),MONTH(A2),1)

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