Grouping Results in a pivot table

[SOLVED]
Hi all,
I have a table where column 1 is names, column 2 is Gender (M/F) and column 3 is a series of rankings (number).
The numbers range from -10 to 0 and above to 10. I have created a pivot where down the left hand side I have the Gender and across the top it has all of the numbers from the rankings with a count to how many have that ranking. what I would like to do is group the rankings so all the minus numbers come under "Not achieving" all of the zeros come under "Achieving" and anything above is "above Target" and then we have a count of how many for each one for Male and female.

I have seen some one do this but for the love of glob I cant remember the function I need.

Any help is greatly appreciated. I have attached a dummy doc to explain (the pivot table is for another much larger workbook but I hope the dummy doc illustrates what it is I am trying to do)

Thanks
Jon

Maybe insert a helper column in your data set and create the grouping labels, then pivot the data with the grouping label.

You already answered your own question. If you have more than five categories, then a reference table is highly recommended.