ok... Morgan using what you showed i am now able to get a sum of all reps
which is great!
but its not then summing those up for manager, and then total for all..
it just repats the last iteration.
<!--- Display Market Header --->
<cfset sumTotal = 0><!--- --->
<cfoutput query="get_Sales" group="Market">
<h3><cfif get_Sales.Market IS 1>
Industrial Sales Reps
<cfelse>
IT Sales Reps
</cfif></h3>
<!--- Display The Manager of that Market --->
<cfoutput group="Manager">
<!--- this is used to add up each manager's reps. Reset to 0 at the start of
each new manager --->
<cfset sumTotal = 0><!--- --->
<cfset subTotal = 0><!--- --->
<h4>#get_Sales.Manager#</h4>
<h5>Name - Total Leads - Rep Company</h5>
<!--- Display The Sales guys under the Managers --->
<cfoutput group="usr_fname">
<!--- Do a count on all the leads for each sales guy. this works just fine
--->
<cfquery datasource="#request.dsn#" name="get_leads">
Select Count(*) AS total
>From Leads
WHERE rep_assigned = #get_Sales.usr_id#
</cfquery>
<!--- Display our basic info --->
#get_Sales.usr_fname# #get_Sales.usr_lname# :: #get_leads.total#<br>
<CFSET sumTotal = #sumTotal# + #get_leads.total#><!--- --->
</cfoutput><br>
<!--- This will display each manager's total for all their Rep's --->
<span class="style1">Rep's Total: #sumTotal#</span><!--- --->
<!--- this adds this manager's subtotal to the overall total --->
<!--- ---><br>
by Market: #sumTotal#
</cfoutput></cfoutput>
<!--- This is the overall total for all managers ---><br>
overall total: <cfoutput>#sumTotal#</cfoutput>
<!--- Now for each loop of sales guys i want to sum up all there
get_leads.total --->
<!--- A. for each managers group - This Works!--->
<!--- 1. Total by Market: dosnt work --->
<!--- 2. ovelrall total: dosnt work - sume for all in combined Markets so
thats all the sales guys totals --->
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295944
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
