title: Weighted Averages in PowerView
body: <p>My objective is to create a weighted average of price where the weights depend on the value of size per category, using the PowerView functionality in Excel 2013. For instance the following table: </p>
  
  <p>Table</p>
  
  <pre><code>Category  Price    Size
  1         10        5
  1         20       15
  2         30        3
  2         50        8
  3          5       10
  3         33       10
  </code></pre>
  
  <p>So, for category 1: (10*5+20*15)/20=17.5 and present this in a table:</p>
  
  <pre><code>Category   weighted avg price
   1         17.5
   2        ....
  </code></pre>
  
  <p>Instead of the unweighted averages which the standard functionality of PowerView produces. Is this possible?</p>