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


Get only unique values of a field


     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