Filter by max value

[HelenaBow12_]

Hello everyone! I am currently struggling with filtering the data in the table. I have created an example of my data in Excel and it looks like the following.

I now need to filter the strings by the highest revision number. So, my final table looks like this:

I am new to Qlik, so I am not quite sure how to perform this. 

Thank you in advance for your ideas!

[BrunPierre]

One front end approach could be as follows.

Dimension: OfficeID, SalesPerson, ExpectedOrderDate and Revision

Use the expression below for the Amount.

=Sum(Aggr(FirstSortedValue(Amount,-Revision),OfficeID))