Pivot Table Problem
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! |
Pivot Table Problem
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... -- HTH... Jim Thomlinson "Liz J" wrote: 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! |
All times are GMT +1. The time now is 03:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com