Please find the sample data in attachment. I need to create a straight table with vin's details not reported in previous year i.e. (current year-1). For eg :- now 2015, vin's not reported in 2014. Need to display in table.
Expected output for sample data is given in excel file.
I need to create straight table with vin details which are not reported in previous year. Those vin details (Name , address etc) are available in table, that i will manage later. i need to filter only those vin's not reported in previous year in straight table.