Hi! I am wondering whether there is a way to count in a summary field for only how many unduplicated record are there. for example, there are 3,2,2 customer(s) from company A,B,C respectively, how to count the number of the companies of all the customers, which is supposed to be 3? if simply set the summary field to be the COUNT OF field COMPANY, it apears it will be calculated to be 7=3+2+2.
Thanks so much in advance.