Using Filter Tool

MENDAN

Hi All,

I want to be able to filter out the row that has the MAX number under LastUsPeriod column. This here is duplicate data based on level @ column but I only want to keep rows with the maximum LastUsPeriod number. How can I do this and then combine it with the rest of my data?

image.png

ChrisTX

Can you provide sample input and expected output?

you mentioned:

filter out the row that has the MAX number under LastUsPeriod 

keep rows with the maximum LastUsPeriod number

I'm thinking "filter out" is the opposite of "keep"

You could likely use tools like Filter and Summarize and Join.

Chris