Distinct Count across multiple columns

[NewGuy1983]

Hello,

Was hoping someone could help me display this data correctly. I'm able to get the correct counts but I can't get my list to display right.

Below is a mock up of data.

Instrument             UserName   ticket id
drums             john           758654
drums             john           758655
bass guitar          john           548933
acoustic guitar     john           123456
guitar             john           123456
guitar             john           123457
guitar             john           123458


I'm using the formula - count(distinct [ticket id] for [User Name],[Instrument])
But this displays my list as below.

User Name          count
john                    1
                          2
                          3
total                    7

The correct count is 7 but I would expect 7 to be listed as a detail line. Is there just a setting in the query that I need to set? I'm using cognos analytics 11.0.12.
Any help is greatly appreciated. Thanks

[NewGuy1983]

Just changed the detail aggregation to total and now its working. Never mind!

Hopefully this can help someone else