Get the maximum of that for each State. This is done as another query in Access, in Tableau it can be another LOD expression. Join the results from step 1 and step 2 back to a query at the level of Category & State. This requires yet another query in Access, in Tableau this is a built-in feature of LOD expressions.
More recently, docosanol has been approved by the Food and Drug Administration (FDA) as a pharmaceutical antiviral agent for reducing the duration of cold sores caused by the herpes simplex virus in the OTC medication Abreva. 1 Mechanism and history of antiviral drug usage.
Apply Abreva with a cotton swab or your fingers, but do wash your hands before and after applying the cream. Rub it in gently, and the cream will dry clear. After you have applied the medication, wash your hands again with soap and warm water. Apply Abreva five times a day until healed for up to a maximum of 10 days.