What you are looking for calls grouped Pivot Table:
In the row and column label areas of a PivotTable report, you can group the items in a field in a custom way. Grouping the data can help you to isolate a subset of data that satisfies your specific needs, and that cannot be easily grouped in other ways, such as sorting and filtering.
Group numeric items
Select the numeric field in the PivotTable report that you want to group.
On the Options tab, in the Group group, click Group Field.
In the Starting at box, enter the first item to group.
In the Ending at box, enter the last item to group.
In the By box, type a number that represents the interval included in each group.