I have a report which contains a pivot table. There are two calculated fields, each a numeric score. One is called X axis score, the other Y axis score. The requirement is to list a character value based on the two scores, such as Risk, Performance, Opportunity and Value, and combinations of those values such as Risk/Performance. For example if y < 3 and x < 3 then the character value is "Risk". There are a total of 8 possible values. I was unable to render the character value in the pivot table so I handled via an excel formula. Now, of course, the user wants to filter the pivot table based on the text value. I added a calculated field that assigns a number for each of the 8 values but I need to show the text in the slicer and not the number. Possibly a second calculated field that returns the text value based on the numeric value? Or is there a better way?