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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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:
I'm closing the question as this cannot be accomplished with a pivot table slicer.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.