Forum Discussion
I need to create a matrix that keeps count of varying categories.
I have a list of patients with demographic characteristics. Here's an example: Patient ID DOB Gender Ethnicity Race MRN Diagnosis Doe, Jane 001 01/01/91 F Non-Hispanic Whit...
have you considered pivot tables ?
You can find the options to create pivot table under menu "Insert->Pivot table"
it will look like picture attached. once you create a pivot table , you can drag the different field to rows/columns
