OK....here is a display of a data table that has 200 rows, with 118 different IDs and contains a date and an Expense column.
![merge1.PNG merge1.PNG](https://community.jmp.com/t5/image/serverpage/image-id/26796i9A4383D1815E6830/image-size/large?v=v2&px=999)
What I want is a data table with just one entry per ID and for the date to be the last date the person had a transaction, and I want to know the sum of the expenses. So I go to
Tables=>Summary
and it brings up the following Dialog window which I fill in the information to group by IDs, return the Maximum Date value and the Sum of the Expenses
![merge2.PNG merge2.PNG](https://community.jmp.com/t5/image/serverpage/image-id/26797i59C8E427CFADCAF3/image-size/large?v=v2&px=999)
I then click on the OK button and it creates a data table with the summary statistics
![merge3.PNG merge3.PNG](https://community.jmp.com/t5/image/serverpage/image-id/26798iA0C69CE25A20E5FD/image-size/large?v=v2&px=999)
I could have also gotten the same results by using the Tabulate Platform
Analyze=>Tabulate
It is a drag and drop report writer, that once you have the report the way you want, you can go to the red triangle and request that a data table be made from the report
![merge4.PNG merge4.PNG](https://community.jmp.com/t5/image/serverpage/image-id/26799iC095BD763A71969B/image-size/large?v=v2&px=999)
Jim