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.
Marketed by Avanir Pharmaceuticals, Abreva was the first but not the only over-the-counter antiviral drug approved for sale in the United States and Canada. In Europe, it is marketed by Healthcare Brands under the name Erazaban. In the UK it is known by the name Blistex Cold Sore Cream.