grouping dates in a pivot table

P

pat67

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top