How to Exclude the last week when a

Thanks for taking the time to respond to my problem. When I used your formula nothing changed with my results. I am not sure if it has to do with how my dashboard is modeled.