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.
<TBODY>
</TBODY>
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.
| Year</SPAN> | Values</SPAN> | ||
| 2013</SPAN> | |||
| MgrEmail</SPAN> | Customer Name</SPAN> | Count of Customer Name</SPAN> | Sum of SalesDollarAmount</SPAN> |
| alexart@cdw.com</SPAN> | FRANCISCAN MEDICAL GROUP</SPAN> | 1</SPAN> | $752</SPAN> |
| ST. JOHN HEALTH SYSTEM</SPAN> | 1</SPAN> | $755</SPAN> | |
| GIFFORD MEDICAL CENTER</SPAN> | 1</SPAN> | $899</SPAN> | |
| alexart@cdw.com Total</SPAN> | 1</SPAN> | $2,406</SPAN> | |
| alexcoo@cdwg.com</SPAN> | BRIDGESTONE/DES MOINES</SPAN> | 1</SPAN> | $842</SPAN> |
| alexcoo@cdwg.com Total</SPAN> | 1</SPAN> | $842</SPAN> | |
| alexmus@cdw.com</SPAN> | CORPORATE EXECUTIVE BOARD</SPAN> | 1</SPAN> | $1,523</SPAN> |
| MEADWESTVACO</SPAN> | 1</SPAN> | $4,526</SPAN> | |
| ADVISORY BOARD COMPANY</SPAN> | 1</SPAN> | $2,554</SPAN> | |
| BOOZ AND COMPANY</SPAN> | 1</SPAN> | $4,566</SPAN> | |
| DUNBAR ARMORED INC</SPAN> | 1</SPAN> | $8,845</SPAN> | |
| RADIO ONE INC</SPAN> | 1</SPAN> | $457,861</SPAN> | |
| alexmus@cdw.com Total</SPAN> | 1</SPAN> | $479,875</SPAN> | |
| bradjus@cdw.com</SPAN> | PHH CORPORATION</SPAN> | 1</SPAN> | $78,723</SPAN> |
| SODEXO</SPAN> | 1</SPAN> | $12,545</SPAN> | |
| MENTOR NETWORK</SPAN> | 1</SPAN> | $11,542</SPAN> | |
| HALLER ENTERPRISES INC</SPAN> | 1</SPAN> | $878</SPAN> | |
| MCCORMICK AND COMPANY INC</SPAN> | 1</SPAN> | $546</SPAN> | |
| MIDDLEBURG BANK</SPAN> | 1</SPAN> | $74,656</SPAN> | |
| bradjus@cdw.com Total</SPAN> | 1</SPAN> | $178,890</SPAN> | |
| briacos@cdw.com</SPAN> | QLOGIC CORPORATION</SPAN> | 1</SPAN> | $65,897</SPAN> |
| briacos@cdw.com Total</SPAN> | 1</SPAN> | $65,897</SPAN> | |
| bryadaw@cdw.com</SPAN> | NATIONAL INSTITUTES OF HEALTH</SPAN> | 1</SPAN> | $254,647</SPAN> |
| bryadaw@cdw.com Total</SPAN> | 1</SPAN> | $254,647</SPAN> | |
| bscham@cdw.com</SPAN> | CHS, INC.</SPAN> | 1</SPAN> | $125,456</SPAN> |
| bscham@cdw.com Total</SPAN> | 1</SPAN> | $125,456</SPAN> |
<TBODY>
</TBODY>
Last edited:
