National Outdoor Challange BSA

I am trying to generate a report for this award. The difficult part seems to be calculating the percentage of youth who attended CAMPOUT. I don’t seem to be able to filter dates, to a one year attendance range, or limit events categorized as CAMPOUT.

Would love help!