Hi,
I have searched through previous discussions but I haven't been able to find the answer to my particular question. I want to the totals to appear for each year rather than an overall total. I have tried ticking the partial sums I don't get the totals for the year (name, year boundary are all dimensions).
This is what I get
| | Boundary | Total | High | High | High | Inlier | Inlier | Inlier | OneDay | OneDay | OneDay |
| Name | Year | | 2010 | 2011 | 2012 | 2010 | 2011 | 2012 | 2010 | 2011 | 2012 |
| A | | 125 | - | 3 | 3 | 42 | 34 | 41 | 1 | - | 1 |
| B | | 43 | 1 | - | 1 | 9 | 12 | 15 | 2 | - | 3 |
| C | | 16 | - | - | - | 4 | 5 | 4 | 1 | 1 | 1 |
This is what I want
| | Boundary | Total | Total | Total | High | High | High | Inlier | Inlier | Inlier | OneDay | OneDay | OneDay |
| Name | Year | 2010 | 2011 | 2012 | 2010 | 2011 | 2012 | 2010 | 2011 | 2012 | 2010 | 2011 | 2012 |
| A | | 43 | 37 | 45 | - | 3 | 3 | 42 | 34 | 41 | 1 | - | 1 |
| B | | 12 | 12 | 19 | 1 | - | 1 | 9 | 12 | 15 | 2 | - | 3 |
| C | | 5 | 6 | 5 | - | - | - | 4 | 5 | 4 | 1 | 1 | 1 |
