Skip to main content
Asked a question last year

How would I remove customer duplicates in my datagrid so it only shows data from the most recent transaction? For example, I have 5 transactions from 1x customer but only want to show the newest on my report.

Where am I?

In Yurbi you can ask and answer questions and share your experience with others!

If you have a transaction date field that you can add to the report, you can add a formula on that field: max(?) 

This should give the record that has the most recent date, but it will group by all other fields in the report. If all your other columns in the report are unique per customer then this should provide the results you are looking for. If you have other fields such as a status fields for example and transactions are in different status states you would need to use a different method. If this is the case let us know by providing us with some sample data and we can help you from there.

Related Questions

No related questions.