Pivot Table Problem

L

Liz J

Before creating my pivot table, I did a format change with a column of dates
on the data source. I formated the dates to show only the month name
(format: mmmm). When I put together the PT (with MS Excel 2007 software), it
would show 3 rows of January, 4 of February, 4 March, etc. Instead of 1 row
for each month January through Decemeber. Do you know why this is happening,
and how I could fix it?

Thanks for your help!
 
J

Jim Thomlinson

Pivot tables aggregate values based on like members. If you have a column of
dates then each date is a unique member which will be treated seperately.
Even if you format the dates, the underlying data is still individual dates.
That being said pivot tables have the ability to group. Select the Date field
and right click. Select Group and you will be able to group by month, year,
quarter, day...
 

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

Top