PIvot table column heading

[Guest]

HI guys, Hoping you can help.

I have a pivot table that has "status" for rows and "months open" for
columns. I want to change the column headings to use months 1 thru 6 and
then lump anything over 6 months together.

instead of: 1,2,3,4,5,6,7,8,9,10,11
i want : 1,2,3,4,5,6,>6

Is that possible?

Thanks in advance,
Matt
(access 2002)

 

[Guest]

Matt,

Best bet is to use a computed column for your columns instead of using the
[Months Open] column as the column headers, use something like:

Months: IIF([Months Open] < 6, [Months Open], " > 6")

HTH
Dale