HI
I have data which looks like this
Date | Object | Value |
9/1/13 | abc | 2 |
9/2/13 | def | 3 |
9/9/13 | ghi | 4 |
9/16/13 | jkl | 5 |
9/18/13 | abc | 1.8 |
9/20/13 | def | 2.5 |
I want to take snapshots at different dates say maybe every Sunday 9/7 9/14 and 9/21 and sum up the latest values for each available object. If nothing is selected, then a pivot table representing what I would like to see would look this
9/7/13 Total 5
abc 2
def 3
9/14/13 Total 9
abc 2
def 3
ghi 4
9/21/13 Total 13.7
abc 1.8
def 2.5
ghi 4
jkl 5
I have tried using aggr() but somehow I am not able to get it to work.
Any help would be appreciated
Thanks
Sid