Nov 04 2021 07:29 PM - edited Nov 04 2021 08:36 PM
I have two date columns, one for onset of illness and the other date of vaccination. I have a third column with resident role( Eg: Resident, Visitor, Contractor etc) I want to count the number of residents who had a vaccine before they got the illness, same applies to Visitor and contractor.. I have created a dummy file. I have a two date columns with over 1000 rows. Thanks for the help
Nov 04 2021 07:49 PM
SolutionAdd a helper column "Vaccine before illness":
=[@Vaccination]<[@Illness]
Insert a pivot table:
"Vaccine before illness" in report filter area. Filter on TRUE.
"Role" in rows area and in values area.
Nov 04 2021 08:37 PM
Nov 04 2021 10:27 PM
Nov 04 2021 07:49 PM
SolutionAdd a helper column "Vaccine before illness":
=[@Vaccination]<[@Illness]
Insert a pivot table:
"Vaccine before illness" in report filter area. Filter on TRUE.
"Role" in rows area and in values area.