@Gianni Ceresa Thank you! That's perfect. I'll check them out there.

@Gianni Ceresa, How do you determine what the generated query is in Oracle Analytics Desktop?

Fred Kaffenberger-Oracle , is this line, (sum(count(ID) * WEIGHT by HOBBY, SEX, REGION)), basically doing an GROUP BY on the ID, HOBBY, SEX, and REGION? I've tried adding these calculations in, but I must be missing something. I'm not getting the same totals. The sample workbook is attached.

Gianni Ceresa, I think splitting the data like you suggest would make the most sense, logically. At least this way, the ID is always unique and tied to the weight and other demographics. However, I'll also try the ranking idea to see if I can get that to work.

Maybe…? Sorry, still very new to OAC. What I'm really trying to do is get a weighted count. So, each respondent represents x number of people in the total US population based on their demographics. This is their weight, and is already calculated in the dataset. All respondents with the same demographics (age range, sex,…