
1. Re: Calculating the Sum of a Weighted Percent Change
Aaron Rubinstein Nov 27, 2012 3:15 PM (in response to Aaron Rubinstein)In case it helps, I have attached an Excel workbook that has an example of the chart I am trying to setup in Tableau. I can get the "Weighted % Change" for Product A and B using a table calc, but I cannot figure out how to chart the "Overall Weighted Cost Change" which is the sum of the Weighted % Change for each product.

Example Data.xlsx 15.8 KB


2. Re: Calculating the Sum of a Weighted Percent Change
Tracy Rodgers Nov 27, 2012 4:24 PM (in response to Aaron Rubinstein)Hi Aaron,
You can do this by creating a calculation similar to the following and creating a dual axis with Weighted % Change:
window_sum([Weighted % Change])
I have attached the workbook.
Hope this helps!
Tracy

3. Re: Calculating the Sum of a Weighted Percent Change
Aaron Rubinstein Nov 27, 2012 4:34 PM (in response to Tracy Rodgers)Perfect, thanks Tracy! I'm still trying to wrap my head around table calculations.
Do you know if it's possible to hide the second axis, since it is kind of redundant in this example (same scale and units)?

4. Re: Calculating the Sum of a Weighted Percent Change
Tracy Rodgers Nov 27, 2012 4:37 PM (in response to Aaron Rubinstein)Glad I was able to help! Right click on Sum of Weighted % Change on the rows shelf and uncheck 'Show Header.'

5. Re: Calculating the Sum of a Weighted Percent Change
Aaron Rubinstein Nov 27, 2012 4:44 PM (in response to Tracy Rodgers)Awesome, thanks again!