Can you show previous weeks data. Its not clear on what basis last 2 items you want to filter out.
Basically the points in below line are not clear.
I am looking for some help creating a list (string) of products that are NEW v/s the previous week while removing the products that are active this week and last week.
how you define NEW and Do you want to remove active products or include ?