1 Reply Latest reply: May 15, 2014 9:51 AM by rebecca _ RSS

    Need help with counting non duplicates

    rebecca _

      I would like to be able to count all the unique values of a field, but not display the field in the summary.  Any ideas?

       

      Background:  I have 3 fields: process, unit, account.  Some of the rows are duplicative and I would like to elimate them.  I want to know how many unique account had each type of process by unit.  I want my summary to look like...

       

      Unit (key down), Process (key across), Account (measure count), but the account numbers should only count if they are unique... any ideas for me?