Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Partial sums on your year dimension might give you what you're looking for.