Combining information from multiple rows

[petersw]

Hello,

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...

 

[jarjarbingie]

Hello,

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...

(1) Create a pivot table.
(2) Drag ID and Date into Rows.
(3) Value into Values and change the field settings to Sum.