Can FirstSortedValued() Solved? *with sample attached
Hi gurus,
have a look at the attached file. My database consist of single individual record, with the data. Due to our data is not 'clean', there are duplicate record, usually a bus_name will have only one date attached to it.Multiple dates are those that are due to our data is not clean.
Have a look at BMW and Audi records, for BMW records, there are three dates namely, 7, 8 and 18. We are suppose to look at which record gives the lowst amount of passenger and take that record. For this case 7th has 700 passengers, 8th has 700 too and 18th has 400. We would want to eliminate the 7th and 8th records and only compute 400 if they ask for BMW number of passengers.
Audi wise, 9th and 20th, 9th total amount is 590 and 20th is 690. Therefore, we would want to choose the lowest amount which is the 9th value. I tried using firstsortedvalue but it seems that it is not working as it will only take one record and does not sum up.
