| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Grouping Date Data in a Pivot Table
Hello,
I've created a pivot table that counts daily events and I would like to show that data monthly or weekly by grouping the Date field in my pivot table. Is this possible? Thanks! Raymond |
|
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Grouping Date Data in a Pivot Table
Add the Date field and Right click on it. Select Group and then you can group
by month, quarter, year, ... If you have any trouble then look at this web site... http://www.contextures.com/xlPivot07.html -- HTH... Jim Thomlinson "Raymond" wrote: Hello, I've created a pivot table that counts daily events and I would like to show that data monthly or weekly by grouping the Date field in my pivot table. Is this possible? Thanks! Raymond |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| grouping date in pivot table | New Users to Excel | |||
| Grouping Date Data in a Pivot Table | Excel Worksheet Functions | |||
| Grouping Date Data in a Pivot Table | Excel Worksheet Functions | |||
| Grouping By Date in Pivot Table | Excel Worksheet Functions | |||
| Date grouping in Pivot Table | Excel Programming | |||
![Raymond[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
