I'm trying to do a calculation, in a straight table, that counts the number of customers by a particular category. A person can show up in multiple categories. I want the denominator to be based on the total number of unique customers and the numerator to be based on the total in that particular category. I'm guessing I'd do something with the aggr function or set analysis, but I can't seem to get the correct answer. Any help is much appreciated.