Custom pivot table ranges/grouping

[Golfpro1286]

I am creating a pivot table that feeds from a loan data table to track some installment loan data. In the rows I have "Type" (Auto, Motorcyle, RV, etc.) and "Model Year". In the columns I have customer credit score. I am wanting to group the credit scores in the following ranges:

>=726
725-691
690-671
670-641
640-620 & No Credit Score
<=619

Thanks for any help!

 

[Golfpro1286]

I have a dashboard that has several pivot charts that all have data feeding from the same table of loan information. In this table each row represents a single loan, there are three columns about loan amount (New money, refinanced amount, and total loan amount). I was hoping to add a slicer to my dashboard that would allow me to switch between the data for new money, refinanced money, and total money. Is there a way to do this since those amounts are in 3 separate columns in the table?

Thanks!