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Â® Cream is a cold sore medicine that penetrates deep into the skin and starts to work immediately to block the virus. It is also the only nonprescription cold sore medicine approved by the FDA to shorten healing time, by getting to the source of your cold sore without stinging or burning.