Trouble with multi field running totals

I have to produce multi field running totals for the following criteria.

Area Sales Manager
Type
Business Unit
Month
Year

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...





EE-shot1.png
EE-shot2.png
EE-shot3.png
STOCRICAsked:
Who is Participating?
 
STOCRICAuthor Commented:
I have solved this one myself!

0
 
STOCRICAuthor Commented:
There are 7 ASM, 5 Business Units.
0
 
STOCRICAuthor Commented:
I found the solution myself
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.