count unique
Hi, I have a table with transaction data like the below. transactionID, individualID, product1, a, apple2, a, orange3, b, apple4, b, banana5, c, orange I want to do in tabulate, not using script, to count how many unique individualID by product. Does anyone know how to do this?I can do summary table using individualID and product first, and then do a tabulate on it to get the uniqueID count by pro...