Max date group by users

[saylee]

I have a column as firmname, username, user id, login date in different tables. I want to find out last login date for all usernames for their firms. 

[Syk · Accepted solution]

Add each field to a table visual (this should give you all your data). Then for your login date, click the arrow next to the field and select "Latest". This will be the last login date and will cut down on your # of records to be the max for each user.