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 only to affected areas. Do not get Abreva in your eyes. If you get Abreva in your eyes, rinse immediately with cool tap water. Wash your hands before and after applying Abreva. Apply to affected area on face or lips at the first sign of a cold sore or fever blister (eg, bump, itch, tingle, redness).