title: How to add totals row to excel power query?
body: <p>I have produced a table like the one below by using 'group' function in excel power query</p>
  
  <pre><code>score 1 score 2 score 3
  A   6   25  50
  B   8   30  20
  C   15  15  30
  D   20  0   10
  </code></pre>
  
  <p>I want to add a totals row (equivalent to "show totals for column" in a normal pivot table), so result would be like this</p>
  
  <pre><code>score 1 score 2 score 3
  A   6   25  50
  B   8   30  20
  C   15  15  30
  D   20  0   10
  Total 49    70      110
  </code></pre>
  
  <p>Anyone knows if there is a simple way to do this? Thank you, RY</p>