BajanPaul
asked on
Excel 2007 Pivot Count Distinct Values
Hello Excel Gurus!
I have an excel sheet with 17k rows. I am trying to understand excel pivot tables and want to know if I can use the pivot to display the count of distinct values for one of my columns.
So far, I did use the excel function (=SUMPRODUCT((D2:D17211<>" ")/COUNTIF (D2:D17211 ,D2:D17211 &""))) to calculate the count and it worked. This unfortunately does not tell me how to arrive at the same answer in a pivot table.
Can someone tell me how to calculate the count of distinct values and have it display it on my pivot?
I have an excel sheet with 17k rows. I am trying to understand excel pivot tables and want to know if I can use the pivot to display the count of distinct values for one of my columns.
So far, I did use the excel function (=SUMPRODUCT((D2:D17211<>"
Can someone tell me how to calculate the count of distinct values and have it display it on my pivot?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excel-ManualCount.jpg