
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.