View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jac Jac is offline
external usenet poster
 
Posts: 58
Default How to group Columns in Pivot Table?

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


"Jim Thomlinson" wrote:

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.
--
HTH...

Jim Thomlinson


"Jac" wrote:

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


"Jim Thomlinson" wrote:

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...
--
HTH...

Jim Thomlinson


"Jac" wrote:

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!