I have a pivot chart with a dozen or so columns in. I want to sort the pivot by two of the columns, both of which are expressions. No problem with the first one, I simply add the expression to the initial dimension column and it works. But how do I then sort by the second column (expression) for those items with identical values on the first column (expression)?
I've tried adding it to the second dimension field, which seems to be ignored completely. I've tried working on the expression to sort by expression 2 if expression 1 matches, but no luck.