Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table
In the base data of a pivot table i have a column of dates (from 1st
June to 31st Dec 2007) in the format "29/12/2007". In the pivot table i would like it to summarise the data by month. ie "Dec 2007". So in the base data i added another column Z (original dates in col B) and input "=B2" and then formatted the cell as "mmmyyyy". Whilst this then "looks" ok on the base sheet when you add it to the pivot table it reverts back to its original format. I did then try and format it in the pivot table and whilst i can get it to show as eg"Dec2007" it still retains all of the original rows and will not summarise. Any suggestions please. Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel |