I need to calculate the percentage of "Nutritional Food" for each county, and I keep getting very wrong results. See below
I want "Nutritional food selection"/"Weight" to equal the percentage for each county's distribution.
I'm sure it has something to do with aggregation and/or using LOD, but I can't figure it out.
I've attached my worksheet.
I appreciate any help offered.
답변 10개
You can use:
{FIXED [County] : SUM([Nutritional food selection])/SUM([Weight])}Best, Don Wise -
Please don’t forget to upvote and/or Select as Best by clicking the hyperlink below in the response that answered your question.
