How to group Columns in Pivot Table?

[Guest]

hi,

I have a list of data which the Time values are recorded as 1, 2, 3, 4, 5,
6.....0. & I have created a pivot table like below:-

Count of Total_carton Time
6 7 8 9 Grand Total
Total 20 16 3 52 91

But actually, I would like the Time column in Pivot Table look like
following:-

Count of Total_carton Time
6-7 8-9 Grand Total
Total 36 55 91

Is there any way to modify the data displayed in Pivot Table's column?

Thanks!

 

[Guest]

Right click on th eTime Field and select Group. it will allow you to group
the numbers based on a set interval... That should do it...

 

[Guest]

Hi, Jim

Thanks for replying but I'm not sure what exactly u mean by right-click on
the Time Field. Is it the in the Pivot Table? If yes, I have tried it out,
but there is not place to set the interval for the series. The option is only
allowed to select some columns & grouped them under a new field.
Or I have done something that was not what u meant for?
Please advise...

 

[Guest]

Across the top of the pivot you have the time field (6 7 8 9). Place you
cursor in any of those cells and right click. One of the options should be
"Group and Show Detail". When you select that a Dialog will open showing Min,
Max and Interval. change the interval to 2 and it will group 6-7, 8-9
together.

 

[Guest]

Thanks very much for you guidance...
I got the stuff working now. : )

 

[Guest]

Grouping is very cool, especially if you ever have dates / times. You can
group by year, month, quarter, hour, ... If you get the chance give it a
try...