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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Pivot Table cell values 1
Pivot Table Data Aggregation 0
Excel does not accept text format! 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot table Days to Months 0
DATE Calculations in pivot table 0
grouping dates in a pivot table 1

Top