Pivot Table Question

[mayoung]

I want to create a pivot table, like the one in the picture. I download my work in process out of our business system into excel. One of the columns gives the number of days each work order has been open. My problem is I’m trying to create a pivot table and use that column to set up my ranges Current, 31-60, 61-90, etc. My problem is I don’t know how to create the ranges using the column of days open. Any help would be greatly appreciated.

 

[Alex Blakenburg]

Start with this. In your pivot, right click on "any of the numbers" in the row or column that contains the "number of days each work order has been open".

In the right click drop down box select Group.
In the next dialogue box enter the numbers shown in the picture below and hit ok.