Select Most Recent Record

[nrwlafhus]

I am trying to select to most recent record where Planned = 'N' (for the given combination of dimensions).

Here is my table:

I want the output to only show the following highlighted row:

Is there a way to achieve this using a chart expression?

[rubenmarin · Accepted solution]

Hi, you can using an expression like:

Sum({<Date={"$(=Max({<Planned={N}>} Date))"},Planned={N}>} Tons)

Maybe you need the add a date format:

Sum({<Date={"$(=Date(Max({<Planned={N}>} Date),'M/D/YYYY'))"},Planned={N}>} Tons)