title: Sort entire Pivot table in Excel 2013 by column
body: <p>I have a Pivot Table with many columns.</p>
  
  <p>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.</p>
  
  <p>Example:  </p>
  
  <pre><code>NAME    PRODUCT   SUM
  Joe       A       400
  Joe       B       200
  Joe       B       300
  Alice     A       500
  Alice     A       200
  Alice     C       300
  </code></pre>
  
  <p>If I use the regular sort on the Sum column, I will get the data sorted partially.</p>
  
  <pre><code>Alice      A    500
  Alice      A    300
  Alice      C    200
  Joe        A    400
  Joe        B    300
  Joe        B    200
  </code></pre>
  
  <p>As you can see, the Sum column is sorted only relevant to the Name column.
  I want the whole column to be sorted.</p>
  
  <p>Expected result should look something like this:</p>
  
  <pre><code>Alice      A    500
  Joe        A    400
  Alice      C    300
  Joe        B    300
  Alice      A    200
  Joe        B    200
  </code></pre>