SHow numeric values based on the latest date

I am creating a sales report and need to display numeric values in my matrix based on the latest weeks figures,now I can't use a basic filter as the old weeks have a last week of 52 but the current y...