Counting Distinct values and separating into 3 columns

[#1]

Hi-

I have a straight table that I am looking to show total counts of the # of documents associated with a certain type of "document type".

I tried using =if(DocType = 'DocTypeA', count(distinct(DocID))) for the first DocType expression, and substituted 'DocTypeB' and 'DocTypeC' for the other two expressions.

In some cases, it is working, but in cases that the 'Person' (my dimension) has multiple 'document types' , it will only show the first expression total. 

Is this a problem that set analysis can solve?

[giakoum · Accepted solution]

try count(distinct {$<[DocType]={"DocTypeA"}>} [DocID])

[#3]

Like a charm.  Thanks!

[#4]

Like a charm.  Thanks!