Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table in Excel 2007 : Problem with % in Table | Excel Discussion (Misc queries) | |||
Pivot Table problem | Excel Discussion (Misc queries) | |||
Pivot Table Problem | Excel Worksheet Functions | |||
Pivot table problem | Excel Discussion (Misc queries) | |||
Pivot table problem | Excel Discussion (Misc queries) |