LastValue

[Sally3]

Hi 

I wanted to write a script for getting the last Critical, Major value...Based on Date (Last appeared value of each category on a recent date)

As shown below :

[Thiago_Justen_]

Hi there,

What about this?

Final_Table:

Load

        Category,

         LastValue(Date)   As Date,

         LastValue(Major) As Major,

         LastValue(Critical) As Critical

Resident Origin_Table

          Order By    Category Asc;