4 Replies Latest reply on Nov 12, 2018 11:36 AM by Don Wise

# Calculate the weight % of a total

In my blue columns, i have the excel version of the result i'm trying to reproduce in Tableau.  In the formulas section (the . is not part of the formula)  The excel tab is a printscreen from my original data.  I want to find the weight of each parts on the total of the purchasing for all those years

• ###### 1. Re: Calculate the weight % of a total

Hello David,

Please see if the below and newly attached 2018.3 workbook works for you? If yes, please mark as correct. Thx, Don

1 of 1 people found this helpful
• ###### 2. Re: Calculate the weight % of a total

Thanks, thats exactly what i'm looking for.  Thanks for the hint of Stan Lee

Have a nice day

• ###### 3. Re: Calculate the weight % of a total

While Don's answer is correct, you may want to know how to get it right since there are nested/multiple table calculations being used here, one for the Variation and the other for the WINDOW_SUM.

This is for the WINDOW_SUM:

This is for the Variation:

Hope this helps.

1 of 1 people found this helpful
• ###### 4. Re: Calculate the weight % of a total

Thanks David...and I know sad huh!? We'll miss that guy a lot! OK glad to have helped.