How to group Columns in Pivot Table?
 

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!

How to group Columns in Pivot Table?
 

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!

How to group Columns in Pivot Table?
 

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!

How to group Columns in Pivot Table?
 

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!

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!

How to group Columns in Pivot Table?
 

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

Jim Thomlinson


"Jac" wrote:

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!