• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 206
  • Last Modified:

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.
0
HappyAlways
Asked:
HappyAlways
  • 2
  • 2
1 Solution
 
Rory ArchibaldCommented:
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

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now