Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() in excel sheet i have a lot of numbers, and i want to do pivot table from this numbers but to be sorted in some range of numbers and to see it in pivot table in that range! example: 1,09-1,20 1,20-1,60 1,60-1,80 1,80-1,89 1,89-2,60 .... so to have it all sorted in this kind of ranges and not like pivot data is arrange by this intervals. Automatically data is now sorted like this: 1,09 1,1 1,11 1,12 1,13 1,14 1,15 .... which is too much rows in pivot table |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Grouping Dates in Pivottable Excel 2007 | Excel Discussion (Misc queries) | |||
PivotTable grouping by Time Elapsed problem | Excel Discussion (Misc queries) | |||
PivotTable question about grouping numbers in it | Excel Worksheet Functions | |||
PivotTable grouping problem | Excel Discussion (Misc queries) | |||
Grouping dates in PivotTable/Chart | Charts and Charting in Excel |