Sort entire Pivot table in Excel 2013 by column

Question

I have a Pivot Table with many columns.

I want the Pivot the ability to sort one of the columns in a way that the whole column is sorted and not the relative position in the hierarchy.

Example:

NAME    PRODUCT   SUM
Joe       A       400
Joe       B       200
Joe       B       300
Alice     A       500
Alice     A       200
Alice     C       300

If I use the regular sort on the Sum column, I will get the data sorted partially.

Alice      A    500
Alice      A    300
Alice      C    200
Joe        A    400
Joe        B    300
Joe        B    200

As you can see, the Sum column is sorted only relevant to the Name column. I want the whole column to be sorted.

Expected result should look something like this:

Alice      A    500
Joe        A    400
Alice      C    300
Joe        B    300
Alice      A    200
Joe        B    200

Answer 1

If you have more than one field in the row area of the pivot table, you cannot create a sort purely by value. The hierarchy cannot be ignored. That's how a pivot table works. Don't shoot the messenger.