I'm trying to create a custom report that lists ID, product name, prior months sales, YTD sales, on hand, on order and lead time. The only item I can't figure out is "prior months sales" How can I get this? I would also like to be able to put in a date…