asked on
How to use text values in pivot table?
Need help on Excel from an expert that knows far more than I do. I have a pivot table, but pivot tables cannot display text values as we need. I recall seeing someone who did something similar in the past , but I cannot seem to find anything.
If I recall, formulas were used, but I could not create any that worked for the solution we need.
If this can be done directly in Share point somehow, great, but I can easily refresh the data from a linked .iqy file
Thank a million for looking!
Sample.pdf
Sample.xlsx
If I recall, formulas were used, but I could not create any that worked for the solution we need.
If this can be done directly in Share point somehow, great, but I can easily refresh the data from a linked .iqy file
Thank a million for looking!
Sample.pdf
Sample.xlsx
Microsoft ExcelMicrosoft OfficeMicrosoft SharePoint
Last Comment
Tracy
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Ejgil's attached file above. He's created a pivot table, but in the field settings for his value field, he's created a custom format type that displays the NAME of the value, rather than a simple sum.
ASKER
That's brilliant! Just what we need. Thanks very much, appreciate the help!
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.
I have recommended this question be closed as follows:
Accept: Ejgil Hedegaard (https:#a42461589)
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
broomee9
Experts-Exchange Cleanup Volunteer
I have recommended this question be closed as follows:
Accept: Ejgil Hedegaard (https:#a42461589)
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
broomee9
Experts-Exchange Cleanup Volunteer