Solved

Trouble with multi field running totals

Posted on 2011-03-15
3
340 Views
Last Modified: 2012-05-12
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
0
Comment
Question by:STOCRIC
  • 3
3 Comments
 

Author Comment

by:STOCRIC
ID: 35135666
There are 7 ASM, 5 Business Units.
0
 

Accepted Solution

by:
STOCRIC earned 0 total points
ID: 35136823
I have solved this one myself!

0
 

Author Closing Comment

by:STOCRIC
ID: 35136828
I found the solution myself
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question