hi,
i am new to programming and C# in general and i have to solve this example.i have a datatable on which i want to perform grouping and aggregation. i have detailed the steps below can someone please guide as to whats the best way to do this:-
the datatable contains, date ,num1,num2,num3(for ex), i need to aggregate this data by date in the following fashion
step 1 |
sort date by date asc |
step2 |
add up all numbers and assign todays date and enter in array or.. |
step 3 |
pick the 2nd date and assign total minus 2nd date value to corresponding measure |
step 4 |
iteratively calulate the numbers for all the remaining dates in the array or.. Using this formula, a[i]value=a[i-1]-a[i]
|
pls take a look at the input and ouput i expect
INPUT DATA
date |
num1 |
3-Oct-08 |
100 |
7-Nov-08 |
200 |
20-Aug-09 |
300 |
20-Apr-10 |
400 |
output DATA
date |
num1 adjusted |
Today |
1000 |
3-Oct-08 |
900 |
7-Nov-08 |
700 |
20-Aug-09 |
400 |
20-Apr-10 |
0 |