# Pivot Table groups of values

• Picture a column of decimal fractions representing implied probability scores and alongside a column of 0 or 1 when that decimal value scored

2.00 1
2.02 0
1.90 0
2.00 0
1.85 0
1.90 1
1.80 0
2.00 0
1.90 1

Ordinarily if I inserted that data into a pivot table and had Value; Count and Sum of col B it would look like this:
1.80 1 0
1.85 1 0
1.90 3 2
2.00 3 1
2.02 1 0

Using the results in cols B & C I could divide Sum by Count and work out actual decimal probability scores (real life scenario, there are 100's of thousands of these scores) To nullify the odd peaks and troughs of results, I want to treat scores as groups of 2 say, to average out results, something like this:

1.80:1.85 2 0
1.85:1.90 4 2
1.90:2.00 6 3
2.00:2.02 4 1

You can see I'm grouping and incrementing. The question is how do you define a grouping scenario in a pivot table analysis providing it's doable? I could do it manually but looking for an easier approach, and perform the task daily as fresh data added.

Cheers

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!