title: Sorting an Excel Pivot Table by a calculated field
body: <p>I have the following Excel spreadsheet:</p>
  
  <pre><code>     A              B              C              D    
  1   Product        Category         Sale        Margin
  2   Product A       Apparel          500          45%
  3   Product A       Apparel          400          30%
  4   Product A       Shoes            600          55%
  5   Product B       Apparel          300          20%
  6   Product C       Beauty           100          40%
  7   Product C       Shoes            200          65%
  8   Product D       Apparel          450          25%
  9   Product D       Beauty           700          50%
  10  Product D       Beauty           250          35%
  </code></pre>
  
  <p>Based on this data I create a Pivot Table.
  In this Pivot table I added the following <strong>Calculated Field</strong> to get the profit:</p>
  
  <pre><code>   Profit = Sale * Margin
  </code></pre>
  
  <p>which leads to the following Pivot Table:</p>
  
  <pre><code>            Sum of Profit
  Product A     1.950
  Product B        60
  Product C       315
  Product D     1.540 
  </code></pre>
  
  <p>Now, I want to <strong>sort</strong> this Pivot Table <strong>descending</strong> so it looks like the following:</p>
  
  <pre><code>              Sum of Profit
  Product A        1.950
  Product D        1.540
  Product C          315
  Product B           60
  </code></pre>
  
  <p>It seems that for a <strong>Calculated Field</strong> the sorting options in the <em>PivotTable-Tools</em> is not available.</p>
  
  <p>Do you have any other idea how I can achieve this sorting?</p>
  
  <p><strong>NOTE:</strong> I know that I could add the calculation of the profit in <strong>Column E</strong> in the source data. However, my original file is a bit more complex compared to the simplified example above so a <strong>Calculated Field</strong> is unavoidable.</p>