sub totals in a group by
<p>I have a query which groups by place name and yyyy-mm.  What I would like is to have a combined total of the 3 place names for each month.   For example looking at the below the total of the 3 'places' for 'total1' in march would be 14, 4 + 5 + 5 </p>

<pre><code>   place         yyyy-mm         total1       total2     total3
     A           2016-03           4            4          5
     B           2016-03           5            1          2
     C           2016-03           5            4          2
     A           2016-04           1            3          4
     B           2016-04           2            3          4
     C           2016-04           6            2          1 
</code></pre>

<p>So something like this</p>

<pre><code>    place       yyyy-mm         total1       total2     total3
     A           2016-03           4            4          5
     B           2016-03           5            1          2
     C           2016-03           5            4          2
     ALL         2016-03           14           9          9
     A           2016-04           1            3          4
     B           2016-04           2            3          4
     C           2016-04           6            2          1 
     ALL         2016-04           9            8          9
</code></pre>