Max value for dimension - ignore nulls

[#1]

How can i find what the maximum date for a certain dimension is in the attached data is, ignoring nulls.

i.e. i need to know the most recent date for each market when there was revenue

Is it possible to do this in chart rather than in the load?

[Gysbert_Wassenaar]

You can use the firstsortedvalue for this. See attached qvw.

[jsanchezh]

This might help you

[#4]

That worked Gysbert thanks!

What if I want to only show those markets where the date was more than 3 months ago?