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 |