Hi
Why is your filter the filter the field DateLookup ?
code.sumlookup(lookupset(Fields!DateLookUpKey.Value, Fields!DateLookUpKey.Value,Fields!ActivityTime.Value,"DSData"))
I think there is easier way to do this
first if you want to calculate to total for each Agent, you need to do this :
Sum(Fields!ActivityTime.Value,"AgentName")
then if you want a ratio, all you need is to do:
Sum(Fields!Activitytime.value)/Sum(Fields!ActivityTime.Value,"AgentName")
:w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t: