Output mask on a pivot table?

I have a pivot table that shows avg employee ratings 0.0-5.0.

I would like to show the data in tiers (Tier 1, Tier 2, Tier 3).

Can I do a conditional formating or something that will mask the data and show T1, T,2, T3 instead of the number and then change if I change the underlying data?

In the past I have just copy and pasted values of the table and then find/replace the values. This is fine but inevitabley the numbers change and I need to do the process again.

Thanks for all your help.

If you go to Pivot Table.Formulas.Calculated Field, you can create a new field "Tier" and assign the value as you see fit based upon Rating, e.g. "=if (Rating = 1,1, if Rating = 2, 2, 3))

Hope this helps

SAE

Thank you for the help. This looks like what I need.

Cheers,
Todd