3 Replies Latest reply: Jun 15, 2012 10:47 AM by Michael Burt RSS

    Counting Distinct values and separating into 3 columns

      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?