LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   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?

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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Crate group of date, with Dynamic Range in pivot table not working Tiya Excel Discussion (Misc queries) 3 March 1st 06 02:26 PM
How do I get more columns in a pivot table? bpeltzer Excel Discussion (Misc queries) 0 February 4th 06 07:10 PM
pivot table sort entries that don't yet appear in table rachael Excel Discussion (Misc queries) 11 September 19th 05 11:29 PM
Change Data In Pivot Table John Calder New Users to Excel 1 July 7th 05 10:41 PM
Pivot Table Problems Rachel Gonsior Excel Discussion (Misc queries) 3 March 21st 05 07:24 PM


All times are GMT +1. The time now is 09:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"