How to resolve the old vendor data for current year?
Hi, I have a scenario that a product has a vendor(vendorcode190241) between 7/1/2008to 3/25/2013 and the vendor(030549) has changed from 3/25/2013 to till date. Now I need to query for the old vendor in the current year(2014) but no data is retrieving since that data is available for the new vendor current year. So my requirement is I need to show the Last Year Net Sales and last year data in the current Year for old vendor.How to resolve this issue? Can you please help me? Thanks In Advance.