Calculating Percentiles on Percentage Difference Quick Table Calculation

tableaucommunity@tableau.com — Tue, 29 Apr 2014 20:53:40 GMT

I'm trying to calculate a set of percentiles on top of a percentage difference quick table calculation. Please see the attached Excel file and .twbx file. My desired output is the chart on the Desired Output worksheet in the attached Excel file. The raw data is in the worksheet titled Data in the Excel file. I have a handful of scenarios that projects levels of S&P500 over 20 years. The chart you see depicts percentiles of year-over-year change of underlying scenarios. To create the chart, I calculated the year over year change in the individual scenarios (row 17-26 of Desired Output worksheet in Excel). I then calculated the associated percentiles of the scenarios (row 28 - 34).

In Tableau 8.1, I have created the year over year change for the individual scenarios (Table worksheet). However, when I try to modify the quick table calculation to calculate percentiles, I am getting an error. Any help in the matter is greatly appreciated. Please let me know if you have any questions. Thank you

Content in Tableau Community Forums

Calculating Percentiles on Percentage Difference Quick Table Calculation