Completely non-numeric pivot charts.
I work for an artistic company and we use excell to track the KINDS of items we need, character by character. For some characters, this might be organza or fur, others it might be foam or bolts. We want to be able to have distinct pages showing character by character, but also have up to date modifications if the kind of organza we use changes for all characters. In the past we had dozens of individuals pages (using slicers) and one main page, but they would not all get updated, so confusion ensued.
We like to be able to easily print out a sheet for one character, formatting it uniquely the one time, without haveing to slicer it and format it each time.
I have tried a dozen "Hacks" to use the pivot table, assigning numbers to characters or items so that they would be called in the "data" field, but these are cumbersome and we have so many unique needs that it is almost impossible to create one that works.
I've read a ton of other people online asking the same questions, and without having a background in IT work, the solutions are perplexing.
Surely there are enough arty people who do non-numeric work to make this a well-used option.