How do I count unique values in pivot table Excel 2010

[anich22]

Is there a formula that will calculate unique values in a pivot table? I will need a formula that can be refreshed and automaticall capture changes on a weekly basis?

I will need the count of unique customers by mgr email. I added a count on customer name and showed the value as "index". Although I get a single count on each unique value, the subtotal remains at 1 for the mgremail. Is there a work around formula or better way to accomplish my goal?

Also, I have a subtotal filter to reflect only those customers that have invoice dollars greater than or equal to $750.
[TABLE="width: 727"]
<TBODY>[TR]
[TD][/TD]
[TD][/TD]
[TD]Year</SPAN>
[/TD]
[TD]Values</SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2013</SPAN>
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MgrEmail</SPAN>
[/TD]
[TD]Customer Name</SPAN>
[/TD]
[TD]Count of Customer Name</SPAN>
[/TD]
[TD]Sum of SalesDollarAmount</SPAN>
[/TD]
[/TR]
[TR]
[TD]alexart@cdw.com</SPAN>
[/TD]
[TD]FRANCISCAN MEDICAL GROUP</SPAN>
[/TD]
[TD="align: right"]1</SPAN>
[/TD]
[TD="align: right"]$752</SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]ST. JOHN HEALTH SYSTEM</SPAN>
[/TD]
[TD="align: right"]1</SPAN>
[/TD]
[TD="align: right"]$755</SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]GIFFORD MEDICAL CENTER</SPAN>
[/TD]
[TD="align: right"]1</SPAN>
[/TD]
[TD="align: right"]$899</SPAN>
[/TD]
[/TR]
[TR]
[TD]alexart@cdw.com Total</SPAN>
[/TD]
[TD][/TD]
[TD="align: right"]1</SPAN>
[/TD]
[TD="align: right"]$2,406</SPAN>
[/TD]
[/TR]
[TR]
[TD]alexcoo@cdwg.com</SPAN>
[/TD]
[TD]BRIDGESTONE/DES MOINES</SPAN>
[/TD]
[TD="align: right"]1</SPAN>
[/TD]
[TD="align: right"]$842</SPAN>
[/TD]
[/TR]
[TR]
[TD]alexcoo@cdwg.com Total</SPAN>
[/TD]
[TD][/TD]
[TD="align: right"]1</SPAN>
[/TD]
[TD="align: right"]$842</SPAN>
[/TD]
[/TR]
[TR]
[TD]alexmus@cdw.com</SPAN>
[/TD]
[TD]CORPORATE EXECUTIVE BOARD</SPAN>
[/TD]
[TD="align: right"]1</SPAN>
[/TD]
[TD="align: right"]$1,523</SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]MEADWESTVACO</SPAN>
[/TD]
[TD="align: right"]1</SPAN>
[/TD]
[TD="align: right"]$4,526</SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]ADVISORY BOARD COMPANY</SPAN>
[/TD]
[TD="align: right"]1</SPAN>
[/TD]
[TD="align: right"]$2,554</SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]BOOZ AND COMPANY</SPAN>
[/TD]
[TD="align: right"]1</SPAN>
[/TD]
[TD="align: right"]$4,566</SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]DUNBAR ARMORED INC</SPAN>
[/TD]
[TD="align: right"]1</SPAN>
[/TD]
[TD="align: right"]$8,845</SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]RADIO ONE INC</SPAN>
[/TD]
[TD="align: right"]1</SPAN>
[/TD]
[TD="align: right"]$457,861</SPAN>
[/TD]
[/TR]
[TR]
[TD]alexmus@cdw.com Total</SPAN>
[/TD]
[TD][/TD]
[TD="align: right"]1</SPAN>
[/TD]
[TD="align: right"]$479,875</SPAN>
[/TD]
[/TR]
[TR]
[TD]bradjus@cdw.com</SPAN>
[/TD]
[TD]PHH CORPORATION</SPAN>
[/TD]
[TD="align: right"]1</SPAN>
[/TD]
[TD="align: right"]$78,723</SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]SODEXO</SPAN>
[/TD]
[TD="align: right"]1</SPAN>
[/TD]
[TD="align: right"]$12,545</SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]MENTOR NETWORK</SPAN>
[/TD]
[TD="align: right"]1</SPAN>
[/TD]
[TD="align: right"]$11,542</SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]HALLER ENTERPRISES INC</SPAN>
[/TD]
[TD="align: right"]1</SPAN>
[/TD]
[TD="align: right"]$878</SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]MCCORMICK AND COMPANY INC</SPAN>
[/TD]
[TD="align: right"]1</SPAN>
[/TD]
[TD="align: right"]$546</SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]MIDDLEBURG BANK</SPAN>
[/TD]
[TD="align: right"]1</SPAN>
[/TD]
[TD="align: right"]$74,656</SPAN>
[/TD]
[/TR]
[TR]
[TD]bradjus@cdw.com Total</SPAN>
[/TD]
[TD][/TD]
[TD="align: right"]1</SPAN>
[/TD]
[TD="align: right"]$178,890</SPAN>
[/TD]
[/TR]
[TR]
[TD]briacos@cdw.com</SPAN>
[/TD]
[TD]QLOGIC CORPORATION</SPAN>
[/TD]
[TD="align: right"]1</SPAN>
[/TD]
[TD="align: right"]$65,897</SPAN>
[/TD]
[/TR]
[TR]
[TD]briacos@cdw.com Total</SPAN>
[/TD]
[TD][/TD]
[TD="align: right"]1</SPAN>
[/TD]
[TD="align: right"]$65,897</SPAN>
[/TD]
[/TR]
[TR]
[TD]bryadaw@cdw.com</SPAN>
[/TD]
[TD]NATIONAL INSTITUTES OF HEALTH</SPAN>
[/TD]
[TD="align: right"]1</SPAN>
[/TD]
[TD="align: right"]$254,647</SPAN>
[/TD]
[/TR]
[TR]
[TD]bryadaw@cdw.com Total</SPAN>
[/TD]
[TD][/TD]
[TD="align: right"]1</SPAN>
[/TD]
[TD="align: right"]$254,647</SPAN>
[/TD]
[/TR]
[TR]
[TD]bscham@cdw.com</SPAN>
[/TD]
[TD]CHS, INC.</SPAN>
[/TD]
[TD="align: right"]1</SPAN>
[/TD]
[TD="align: right"]$125,456</SPAN>
[/TD]
[/TR]
[TR]
[TD]bscham@cdw.com Total</SPAN>
[/TD]
[TD][/TD]
[TD="align: right"]1</SPAN>
[/TD]
[TD="align: right"]$125,456</SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]