Solved

Trouble with multi field running totals

Posted on 2011-03-15
3
343 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Adding columns to a table which has non null columns 3 43
Complex SQL Server WHERE CLause 9 40
SQL query 45 41
Set a variable value in SQL Procedure 3 26
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

752 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