Hello,
Looking for some help once again! I have a table with multiple lines of data for a given day, as follows:
<tbody>
</tbody>
From this data, I'd like to be able to summarize the total value for each ID number per day. In other words, the above would result in:
<tbody>
</tbody>
Any great suggestions?? I should add that the full table has over 100 ID numbers, most of which have around 100 days worth of data each. Each day could have 2, 1, or no data associated with it.
Thanks in advance...
Looking for some help once again! I have a table with multiple lines of data for a given day, as follows:
ID Number | Date | Value | |
12345 | 1/1/2010 | 1 | |
12345 | 1/1/2010 | 1 | |
12345 | 1/2/2010 | .5 | |
12345 | 1/2/2010 | 0 | |
23456 | 1/1/2010 | 1 | |
34567 | 1/2/2010 | 1 |
<tbody>
</tbody>
From this data, I'd like to be able to summarize the total value for each ID number per day. In other words, the above would result in:
ID Number | Date | Total Daily Value |
12345 | 1/1/2010 | 2 |
12345 | 1/2/2010 | .5 |
23456 | 1/1/2010 | 1 |
34567 | 1/2/2010 | 1 |
<tbody>
</tbody>
Any great suggestions?? I should add that the full table has over 100 ID numbers, most of which have around 100 days worth of data each. Each day could have 2, 1, or no data associated with it.
Thanks in advance...
Last edited: