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.
Abreva is regarded by many experts as the best way to get rid of cold sores fast. Approved by the FDA, it aims to lessen the severity and shorten the time it takes for cold sores to heal. Abreva has special ingredients that get to work right away, reducing the severity of the symptoms and cutting the healing time.