Excel Pivot Table: Show averages by value range 1

[AllanB1]

Anyone know of a way to group data by number ranges (1-10, 11-20,...)?

I know I can come up with something in a usual spreadsheet, but does the pivot table offer any way like it does with dates, ie., by week?

For example, I need to know an average cost by vendor for 1-10 miles, etc.

Thanks.

 

[SkipVought]

hi,

Anyone know of a way to group data by number ranges (1-10, 11-20,...)?

right click the FIELD in the PT and select GROUP

in the Grouping window, select your Starting, Ending and By values.

the pivot table offer any way like it does with dates, ie., by week?

Group by 7

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[AllanB1]

Won't allow me to group that selection. It's in number format.

 

[SkipVought]

You must have some TEXT values in this range.
[tt]
1. replace these text values with a valid numeric value in your source data

2. Delete your PT

3. Insert a new PT and proceed to group
[/tt]



Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[AllanB1]

Great. Thanks Skip.