I have day wise inventory where some partners are not reporting regularly.. I want to pick latest reported week opening inventory as of Monday and name them as Week1, Week2, Week3 so on for a Quarter. Inventory_date and Partner_Name is key.
I tried doing inner join Max(Inventory_date) group by Partner_Name..
Problem here is some partners have not reported inventory for whole week.
