Solved

Trouble with multi field running totals

Posted on 2011-03-15
3
338 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
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 …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

758 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now