We run a fleet of 100 trucks and please help
1 How many trucks were repaired sorted by vin number ( the count per vin number)
2 How many claims were made, lodged by vin nummber and invoice number
As an expample
Truck#1 had one service only for a month the answer should A63-174 = 1
Truck 2 had a new gearbox fitted and 5 mores claims that were invoiced, the answere should be 5 (so the data regarding truck 2 should have an answer of HB4-0502 = 5
Your assistance is greatly appreciated