Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I create a Total that counts customers only once

Status
Not open for further replies.

AJANETA

IS-IT--Management
Apr 11, 2002
9
GB
Hi

The task i have to to produce a report showing 12 months, and a year to date running total.

That only counts the number of customers who have placed an order in the 1st month of year.

The next month should only then count customers (that were not counted last time) that have placed an order in the 2nd month, (but not the first) and so on, so each month, is a count of new customers, that were not counted before, the year to date is also a running total of customers we are dealing with.
example
customers delt with in period 1.
200
customers delt with in period 2.
180 (these will not be the same customers as in period 1.

year to date

no of customser delt with all year
380

Can you help.

Janet Anderson
Management Information
 
If you're using a SQL database, try creating a View or SP to quickly allow for this data:

select min(orderdate), customer from customertable
group by
customer

Since you really only want the minimum order dates, all you'd have to do then is group by the month and count them.

-k kai@informeddatadecisions.com
 
Running total does not give the correct answer

can you help

I have created 2 running totals that do the following

field1. distinct count = formula field1 = action plan

field2. distinct count = formula field2 = action plan

example

Order Number 12345 field1. = Action Plan Field2. = diagnostic
Running total says Action Plan = 1

Order Number 12346 Field1. = Dignostic Field2 = Action Plan
Running Total says Action Plan = 1.

I know want to add these two togehter, and get a total number of action plans at group Month, and then another total of action plans for the Qtr, and then for the Year.

I am not getting the correct results, where I am going wrong.

Janet
MI



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top