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

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

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