Pivot table in Excel 2010 displaying dates by individual days, but need to be month/period

I am using Excel 2010.

I have a pivot table that displays the dates as individual days, but I need for it to display them as months or periods...how do I do this?
Who is Participating?
NBVCConnect With a Mentor Commented:
Right click on the date column in the PT and select Group... then you can select the periods, etc..
broadcastwarehouseAuthor Commented:
Quick response and was the perfect solution to my problem!

Thanks :)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.