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.
You can't cure HSV or a cold sore, but you can alleviate the pain it causes by avoiding spicy or acidic foods, applying ice, and using over-the-counter remedies. Look for medicines that contain numbing agents such as phenol and menthol to reduce cracking and soften scabs. Abreva is an over-the-counter topical remedy used to help speed healing and minimize pain from a cold sore. It must be used many times a day to speed the healing.