Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to group time field in pivot table
Thx for ur help!
"Mike H." ... I have no idea what your pivot table activity below is doing. Sorry I can't help. "zhurong" wrote: Any other options like the follow : ActiveSheet.PivotTables(PivotName).PivotFields("pa yday").DataRange.Rows(1).Group _ Start:=True, End:=True, periods:=Array(False, False, False, False, True, False, False) "Mike H." ... I'd add some calculations to my original data that contain the date breaks the way you want them. For example, if the date is in col a, in b1 have this formula: =YEAR(A1) & RIGHT("0" &MONTH(A1),2) The above formula gives you 200806 for June, 2008. Put the year first and it sorts better. "zhurong" wrote: hi! My pivot table has a date field,contain data such as "2008-6-1","2008-6-5","2008-6-7","2008-6-10", etc., how can I group time field in pivot table so I can display data group by week or month or by year? Any help will be appreciated! Richard.S.Zhu |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query on Group field in Pivot Table | New Users to Excel | |||
Excel 2007 Pivot Table - Group Field function is not always availa | Excel Worksheet Functions | |||
How to get pivot table Time field to appear correctly | Excel Worksheet Functions | |||
Group Field in Pivot Table €“ Not Enough Room | Excel Discussion (Misc queries) | |||
Pivot table will not group a date field | Excel Discussion (Misc queries) |