troubleshooting Question

How to use text values in pivot table?

Avatar of Bubba Jones
Bubba Jones asked on
Microsoft ExcelMicrosoft OfficeMicrosoft SharePoint
4 Comments1 Solution115 ViewsLast Modified:
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!
Ejgil Hedegaard

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros