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<>"
&""))) 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?