Why won't you group!

Sharkie21

Active Member
Joined
Nov 2, 2005
Messages
319
Why can't I group multiple years in my pivot table? I want to group years 1980-1995 and 1995 -2005. I tried doing a manual grouping, but it just keeps bringing up the automatic grouping. Then I tried changing all the years to numbers and do a number grouping, but it still treated it as years. Help me!
 

RalphA

Well-known Member
Joined
May 14, 2003
Messages
3,829
I don't know about pivot tables, but, I tried a standard, smple chart, in which I used years as my x-values and a straight 1, 2. 3, ... series as my y-values. Only, I entered my years as text, by prefixing each year with a simple quote. Perhaps this approach will work for a pivot table?
 

Forum statistics

Threads
1,077,868
Messages
5,336,861
Members
399,109
Latest member
gdcuk

Some videos you may like

This Week's Hot Topics

Top