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

    Count distinct combinations of two fields



      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.