4 Replies Latest reply: Jun 3, 2013 11:05 AM by David Koschei RSS

    Count Distinct 2 fields in script?

    David Koschei

      Hi everyone,

       

      I have a bar graph dimension:

      FieldA

       

      And I have a bar graph expression:

      Count(DISTINCT FieldB & FieldC)

       

      It works perfectly, however, I don't want FieldC to be available to everyone (I would like to drop it in the script).  However, I still need to be able to pivot on dimension A.  Is there any way to get just the count of distinct B & C for each A in the script, and then drop C?

       

      Thank you