have health data. i want to look at which hospitals ambulances are taking to the most. sorted data by Member ID then day of service then rendering provider speciality (Hospital and Ambulance) then rendering provider (Specific hospital and specific ambulance company). how do i sort or have a formula to only include members and dates where they took the ambulance to the hospital.
attached is an example. everything that is highlighted is what i would want to keep, the rest would be filtered out.