Any chance you'd be able to share a packaged workbook?
So I think I isolated the issue. For some months I don't have any sales. I have sales in March-July but nothing in Jan or Feb so it's grabbing the sales in Dec to get 6 months. I need it to recognize that it needs to stop only look at Feb-July.