Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table - group dates per week or month
In the database we use SALES figures are listed per day. I would like to group them per week, per month in a pivot table. I've tried "Grouping", but get an error message. Who can point me in the right direction to get this done? -- digicat ------------------------------------------------------------------------ digicat's Profile: http://www.excelforum.com/member.php...o&userid=14920 View this thread: http://www.excelforum.com/showthread...hreadid=499205 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table - group dates per week or month
Hi
Make sure that all of the data in the range are true Excel dates. Text values, or blank cells in the range will cause the error message "Unable to group that item". -- Regards Roger Govier "digicat" wrote in message ... In the database we use SALES figures are listed per day. I would like to group them per week, per month in a pivot table. I've tried "Grouping", but get an error message. Who can point me in the right direction to get this done? -- digicat ------------------------------------------------------------------------ digicat's Profile: http://www.excelforum.com/member.php...o&userid=14920 View this thread: http://www.excelforum.com/showthread...hreadid=499205 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why aren't dates always available to group in pivot tables? | Charts and Charting in Excel | |||
Pivot Table, can't group | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) |