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

    Count Distinct 2 fields in script?

      Hi everyone,


      I have a bar graph dimension:



      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