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