Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
I am using a pivot table to look at summary data for our cell phone usage. I
would like to make one big spreadsheet and view the entire year. The call dates on the spreadsheet are mm/dd/yyyy. I would like to be able to put the date on the Page box in the pivot table, but only use the month. Is there a way to do this or do I have to create a new column in the spreadsheet and split out the month there? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
PIVOT TABLE DATE | Excel Discussion (Misc queries) | |||
Pivot Table Question | Excel Discussion (Misc queries) | |||
Date formatting on a Pivot Chart's Data Table | Charts and Charting in Excel | |||
Grouping By Date in Pivot Table | Excel Worksheet Functions |