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
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.
 

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

Similar Threads

Dates In Excel 5
Dealing with a Pivot Table (when I don't want to) 0
Doughnut Chart linked with the slicer in the pivot table 0
Pivot table 0
Creating a Search using a combo box and then creating a report. 4
Pivot Table cell values 1
Pivot table grouping help 0
Pivot Table Data Aggregation 0

Top