Pivot Table Column

Hi ALl,

I am working on this pivot table with column lable is date. The data in date is for 5 years monthly. I want to present the data in grouped years not months.

2011     2012    2013    2014

I am having very difficult time with this.

Any help.
HappyAlwaysAsked:
Who is Participating?
 
Rory ArchibaldConnect With a Mentor Commented:
If the data is actually stored as dates not text, and there are no blank cells in the source data column, then you should be able to right-click, group, and choose group by Year.
0
 
nutschCommented:
Not for points, but completing Rory's answer: check out the attached screencast for this grouping.

Thomas

0
 
Rory ArchibaldCommented:
Thomas,
Not so attached. ;)
0
 
nutschCommented:
Yeah, I got a javascript bug. And I'm not ready to reboot, so no screencast, just follow Rory's instructions and you should be all set.

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