P pat67 Dec 8, 2011 #1 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
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
T trip_to_tokyo Dec 9, 2011 #2 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 Click to expand... 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.
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 Click to expand... 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.
