title: Pivot Table Standard Deviation Help In Excel
body: <p>I have a pivot table like this in Excel:</p>
  
  <ul>
  <li>Column 'item'</li>
  <li>Column 'brand'</li>
  <li>Column 'score'</li>
  </ul>
  
  <p>As I am not very confident with pivot tables, I was wondering if there was a way of getting the standard deviation for each brand?</p>
  
  <p>e.g. (very basic idea)</p>
  
  <p><code>=STDEV(SOMEFUNCTIONTOMAKEARRAY(GETPIVOTDATA(.......)))</code></p>
  
  <p>Thanks</p>