Skip to main content
Topics#Tableau Desktop & Web AuthoringCraig Stiefel の質問
Craig Stiefel が「#Tableau Desktop & Web Authoring」で質問
2025年9月11日 21:15

Calculating percentage of total in a category

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.

 

Calculating percentage of total in a category 

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.

Nutritional % per County (2).twbx
10 件の回答
  1. Don Wise
    2025年9月12日 14:15

    You can use:

    {FIXED [County] : SUM([Nutritional food selection])/SUM([Weight])}

    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

     

    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. 

回答を記入...
0/9000