Filter DataTable to show only the most recent transaction for each user
- by Dan Neely
I have a datatable that contains rows of transaction data for multiple users. Each row includes UserID and UserTransactionID columns. What would I use for as a RowFilter in the tables DefaultView to only show the row for each user that has the highest UserTransactionID value?
sample data and results
UserID UserTransactionID PassesFilter
1 …