Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Crate group of date, with Dynamic Range in pivot table not working | Excel Discussion (Misc queries) | |||
How do I get more columns in a pivot table? | Excel Discussion (Misc queries) | |||
pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot Table Problems | Excel Discussion (Misc queries) |