AnsweredAssumed Answered

Get only unique values of a field

Question asked by PaulWirth on Jan 20, 2014
Latest reply on Jan 20, 2014 by PaulWirth

Title

Get only unique values of a field

Post

     I'm still new to FileMaker and I'm sure there's an easy way to do this:

      

     I have data imported from a bank statement in which more than one transaction can share a common ID. What I want to do is total the transactions for each ID and make an entry into a table I have prepared for exporting as a .csv file.

     So for:

     Amount | ID

     $100     | A1

     $150     | A1

     $100     | A2

     $250     | A3

     $50       | A3

      

     I'd like to be able to create a table view that shows:

     $250     | A1

     $200     | A2

     $300     | A3

      

     Any help? Thanks in advance

Outcomes