AnsweredAssumed Answered

How to get count of multiple values?

Question asked by ohfernanda on Dec 25, 2018
Latest reply on Dec 30, 2018 by steve.thoms


Hello,

 

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!

Outcomes