| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
grouping dates in a pivot table
Hi I have a pivot table that has transactions by date. I want to group
by month and year. How do i do that in the pivot table? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
grouping dates in a pivot table
On Dec 8, 7:22*pm, pat67 wrote:
Hi I have a pivot table that has transactions by date. I want to group by month and year. How do i do that in the pivot table? Thanks EXCEL 2007 Click on one of the dates in the Pivot Table. PivotTable Tools. Options contextual tab. Group group. Click on:- Group Selection The Grouping window should now open. In the Grouping window click on Months and Years so that they are both highlighted in blue. Click:- OK You should now have what you want. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Grouping dates in pivot table | Excel Discussion (Misc queries) | |||
| PIVOT TABLE - GROUPING DATES | Excel Discussion (Misc queries) | |||
| Grouping dates in pivot table by quarters | Excel Discussion (Misc queries) | |||
| Grouping Dates in a Pivot Table | Excel Worksheet Functions | |||
| Grouping dates in a pivot table | Excel Worksheet Functions | |||
Hybrid Mode
