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
[email protected] FRANCISCAN MEDICAL GROUP $750
ST. JOHN HEALTH SYSTEM $800
GIFFORD MEDICAL CENTER $900
[email protected] Total $2,450
[email protected] BRIDGESTONE/DES MOINES $750
[email protected] Total $750
[email protected] CORPORATE EXECUTIVE BOARD $750
MEADWESTVACO $800
ADVISORY BOARD COMPANY $900
BOOZ AND COMPANY $950
DUNBAR ARMORED INC $945
RADIO ONE INC $899
[email protected] Total $5,244
[email protected] PHH CORPORATION $800
SODEXO $841
MENTOR NETWORK $954
HALLER ENTERPRISES INC $999
MCCORMICK AND COMPANY INC $12,546
MIDDLEBURG BANK $23,665
[email protected] Total $39,805
[email protected] QLOGIC CORPORATION $485,445
[email protected] Total $485,445
[email protected] NATIONAL INSTITUTES OF HEALTH $59,746
[email protected] Total $59,746
 
Top