Can you please give me a hand on this. The answer is probably in front of my nose, but I haven't found it yet and I've been struggling with this all day. I'm still fairly new to this....
On my report I have two fields that I'm trying to grab a total from.
The two fields I have are as follows:
The current report I have lists the OfflineReasonID and TotalHoursOffline by date for any user defined period. It also has a Sum field totaling the entire TotalHoursOffline.
In addition to the above, I would like to create another field on this report that would give me a total of TotalHoursOffline based on a specific value in the OfflineReason field for the user defined period?
I need the Sum of TotalHoursOffline where OfflineReasonID = 1000
and just for the time frame that the user entered for this report.
Any ideas how this might be accomplished? Thanks for any help.