I have to produce multi field running totals for the following criteria.
Area Sales Manager
what I'm trying to acheive is the running total for each ASM for each month for each business unit.
EE_shot1 = is how my solution using a subquery is looking for a single ASM. It's not right.
EE_shot 2 = the data on which it's working upon.
EE_shot3 = My attempt to code te solution.
I would really appreciate any help I can get.
thanks, as always...