Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Change Date Values
Greetings,
I've created a pivot table that has dates along the top and quantities sumed in the data field. The problem is that Excel is not combining the date like I want. I want the date columns at the top to be distince my month-year, but excel is distinct for full date. To give an example. I have columns for January 2004 such as this: 01/01/04 01/02/04 01/03/04 I want a single column for January 2004 with quantities added together and not seperated by the day. Please help. Thank you. Rod Neville |
#2
|
|||
|
|||
Change Date Values
Select one of those headers and right click on it.
Choose Group and show detail Group by month (and probably years???). Snakeoids wrote: Greetings, I've created a pivot table that has dates along the top and quantities sumed in the data field. The problem is that Excel is not combining the date like I want. I want the date columns at the top to be distince my month-year, but excel is distinct for full date. To give an example. I have columns for January 2004 such as this: 01/01/04 01/02/04 01/03/04 I want a single column for January 2004 with quantities added together and not seperated by the day. Please help. Thank you. Rod Neville -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change general format to US date format | Excel Discussion (Misc queries) | |||
How to change drop down values based on another cell value? | Excel Discussion (Misc queries) | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
search for latest date | Excel Worksheet Functions | |||
Create new series (on the same chart) for every change of values in a combobox | Charts and Charting in Excel |