How do I create a formula that will refresh weekly

A

anich22

I hope someone can help me with this question, I have created an access
DB to produce all invoice and quote dollare for a specific brand. I
summarized the information into a pivot table. I added a custom filter
to show only those customers with sales greater than or equal to $750.
What formula can I use to capture the number of customers that meet this
threshold on a weekly basis?


MgrEmail Customer Name 2013
(e-mail address removed) FRANCISCAN MEDICAL GROUP $750
ST. JOHN HEALTH SYSTEM $800
GIFFORD MEDICAL CENTER $900
(e-mail address removed) Total $2,450
(e-mail address removed) BRIDGESTONE/DES MOINES $750
(e-mail address removed) Total $750
(e-mail address removed) CORPORATE EXECUTIVE BOARD $750
MEADWESTVACO $800
ADVISORY BOARD COMPANY $900
BOOZ AND COMPANY $950
DUNBAR ARMORED INC $945
RADIO ONE INC $899
(e-mail address removed) Total $5,244
(e-mail address removed) PHH CORPORATION $800
SODEXO $841
MENTOR NETWORK $954
HALLER ENTERPRISES INC $999
MCCORMICK AND COMPANY INC $12,546
MIDDLEBURG BANK $23,665
(e-mail address removed) Total $39,805
(e-mail address removed) QLOGIC CORPORATION $485,445
(e-mail address removed) Total $485,445
(e-mail address removed) NATIONAL INSTITUTES OF HEALTH $59,746
(e-mail address removed) Total $59,746
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I write a formula that will figure weekly overtime? 15
How do I create a formula that will multiply a 5% of a value >$150 2
how do i create a reducing number that reduces at certain dates 1

Top