I would like to get a count based on multiple values. I have a table with fields "Job Title" and "Facility". Currently I am able to get a count of records of individuals working in Facility A, B, or C using PatternCount ( List ( Table::Facility) ; "A" ). However, I would like to narrow down my count to those working in Facility A and have also chosen value X as their Job Title. What calculation would I use?
Thanks in advance!