I have a set of data which contains the following:
<tbody>
</tbody>This data repeats, so sometimes the date with the last value in will be 2011, and sometimes the only value will be in the earliest i.e. 2008.
The output I need is:
<tbody>
</tbody>
Does anyone have any ideas how to do this?
Thanks so much
2008 | 1 |
2009 | 2 |
2010 | 0 |
2011 | |
Charge | XYZ |
<tbody>
</tbody>
The output I need is:
2008 | |
2009 | Sum all XYZ (where last value in 2009). |
2010 | |
2011 |
<tbody>
</tbody>
Does anyone have any ideas how to do this?
Thanks so much