Method Community

Hi All, I am new to Method and trying to use the report designer to create a customer list that shows the customers last invoice date and amount. I can create a customer list and display their invoice history , but I am trying to determine a way to just show the last invoice. I can't do this by date filters because that wouldn't guarantee ...