3 Replies Latest reply on Dec 10, 2013 12:42 PM by Thomas Beaulieu

    Sum of a distinct count

    Thomas Beaulieu

      I have a seemingly easy issue that I cannot solve.  Referring to the attached image, I have a column of customer names and a column of quote numbers.  The quote numbers represent quotations where the customer asked for a quotation on only one item.  I want to get a count of how many single item quotations are furnished per customer.  I can get the list of quotation numbers per customer that only represent on item but not the count.  For instance, I want Morgan Kiser to show "1", Morimatsu to show "2" and so on.  When I run any kind of CountD() function on my quote numbers the value returned is "1" for everything. 

       

      Any ideas?Capture2.PNG.png