I have created a Google Sheet to enter data of a hospital. One of the column is 'GENDER
' where I have created drop down using data validation -> list of items
and the items are (M,F
) and similarly I have created another drop down value for the column 'CASES
' where values are (NORMAL CORONA,DISCHARGED,DIED,ISOLATION,VENTILATOR,COMA
). Health workers will input data in this sheet. I have neglected other columns.
Sample columns in the sheet (first tab named 'data
') are:
S.NO.|| NAME || GENDER || ADDRESS || CONTACT_NUM || CASES || ADMIT_DATE || OCCUPATION||RELATIVES_NAME||RELATIVES_CONTACT
Now in another tab, I have to give the aggregate report of the hospital patient. The structure of the aggregate report will be:
NORMAL CORONA DISCHARGED DIED ISOLATION VENTILATOR COMA
MALE
FEMALE
How can I create a report in google sheet from the drop down data list which shows total number of M/F
gender count for the different CASES
.