When working with pivot tables in Excel 2010, I want to show my pivot in compact form, with each field being indented as you move through the data, like so:
However, some of my data strings are actually very long, and this significantly reduces the readability of the pivot, as seen here:
To correct, I thought I could simply resize the rows and wrap the text, but this causes the indentation to be removed automatically, like this:
I've tried playing around with the few options I can think of to make this work. I can manually indent each field after wrapping, but any time the data is refreshed, this gets funky, with or without preserving formatting.
Is there a simple way I can make this work? Am I just stuck with one option (indentation) or the other (wrapping)?