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.
LOVAZA, a lipid-regulating agent, is supplied as a liquid-filled gel capsule for oral administration. Each 1-gram capsule of LOVAZA (omega-3-acid ethyl esters) contains at least 900 mg of the ethyl esters of omega-3 fatty acids. These are predominantly a combination of ethyl esters of eicosapentaenoic acid (EPA - approximately 465 mg) and docosahexaenoic acid (DHA - approximately 375 mg).