Hello i want to select the range and want to do sum . please see the table
| value | Count |
|---|---|
| 50 | 2 |
| 78 | 6 |
| 120 | 4 |
| 180 | 3 |
| 210 | 5 |
above is my table now i want to look it like table below in range of 100's .
| Value | Count |
|---|---|
| 100 | 8 |
| 200 | 7 |
| 300 | 5 |
here the range of 0-100 , 100-200 and 200-300.
Please suggest me some way to do it. Thanks