Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PivotTable question about grouping numbers in it
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
PivotTable question about grouping numbers in it
I think the easiest approach would be:
In the original data, use an additional column with a forumla that indicates which group the row falls in, then use this column in your pivot table. of course this assumes the original data is in a worksheet. In a database, you could use a group clause in the query possibly. -- Regards, Tom Ogilvy "Ivica TypeR" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
PivotTable question about grouping numbers in it
yes, realy, haven't think on that , this should be the best soulution
and i will do it. Data IS in worksheet! tnx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |