| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
organising dates in pivot table column
I have a very simple 3 column list of data. Date, Item purchased, Cost. I have created a simple pivot table with item as the {Row}, Date as the {column} and sum of cost as the {Data} field. I have grouped the date columns into months by right clicking on the pivot table column heading and selecting group. However my data covers the period 1 Jan 2005 to 31 Mar 2006. By grouping up my data into months I find that the pivot table does not see a difference between jan 05 and jan 06, feb 05 and feb 06 etc. How can i pivot table my data and end up with 15 columns (jan 05 to Mar 06) and not 12 (jan to Dec) Whilst on this theme is it possible to have the date shown as mmm-yy. I only seem to have the choice od dd-mmm-yy or mmm. Many thanks Jack -- jack straw ------------------------------------------------------------------------ jack straw's Profile: http://www.excelforum.com/member.php...o&userid=34482 View this thread: http://www.excelforum.com/showthread...hreadid=542428 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table column independence | Excel Discussion (Misc queries) | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Need to Add Column to Data in Pivot Table | Charts and Charting in Excel | |||
| Pivot Table -- Add column to average Grand Total | Excel Worksheet Functions | |||
Threaded Mode
