Show an alias for a value in an Excel slicer

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?
TforTxAsked:
Who is Participating?
 
TforTxAuthor Commented:
I'm closing the question as this cannot be accomplished with a pivot table slicer.
0
 
gowflowCommented:
Can you post your workbook ?
gowflow
0
 
TforTxAuthor Commented:
Unfortunately I can't.  By the time I stripped out what I must, it wouldn't provide much help.  After posting my question, I realized that the calculated field I built is of no value, as a slicer can't be a calculated field.  To return the value is the data would require a complete re-write, as it is based on many other values.
0
 
gowflowCommented:
So now what is your question if question you still have ?
gowflow
0
 
TforTxAuthor Commented:
A pivot table slicer cannot be based on a calculated field, but must be returned in the data.   My intent was to do as many calculations as possible in the pivot table, which I did.  The field I want to filter or slice on is a final calculation based on other calculated fields.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.