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: