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.