3 Replies Latest reply: Jan 26, 2015 6:56 AM by Aaron Morgan RSS

    Count distinct combinations of two fields

      Hello,

       

      I would like to calculate a simple Count of distinct combinations of two fields.

       

      The two fields are %Product and %Depot. To count the unique combinations of %Product and %Depot, do I need something like the following?

       

      =Aggr(Count(Distinct %Product),%Depot)


      Not sure if I'm on the right track...the equation will just be used in a straight table.

       

      Thanks!

       

      Mel