Hi autoexcrement!

Thank you again for your quick response.

Could this be done in more steps but easier to follow?

I tried reading upon what CTE and (SELECT RN = ROW_NUMBER() OVER (PARTITION BY

do, but I cannot get the jist of it 🙁

I will try and do what you suggested using the date filters.

Thanks a lot for your time 🙂

Tammy