Counting unique spending heads

I have a column with employee names and another column for their expenses. Each row represents a transaction made. How do I count unique spending heads for each month and avoid double counting names on QS?


Hi @bettersinner, have you tried the newly launched Level-Aware-Calculation, with which you will be able to specify the calculation a specific level? In your case, based on your data type of the month, you can try to define a calculation something like count({expense}, [{Employee name}, {month}]).