2 Replies Latest reply on Nov 29, 2016 7:42 AM by Walt Reed

Quick Calculation: Percentage of Difference from First

Siang Li Chua Nov 28, 2016 6:50 PM

Hi. My total population is the same 550 people who did a yearly survey. Pls see the chart below. I am trying to add an annotation on the difference between those responded "Yes" in Year 2016 and Year 2012. So I use quick calculation (see pic further down). I am expecting 482 - 428 = 54. But somehow 360 is given. Similarly, I want the % of difference and expecting 54/550 = 9.8% but a wrong 295.1% was given. What should I do to get the correct computation? Thanks much.

1. Re: Quick Calculation: Percentage of Difference from First

Norbert Maijoor Nov 29, 2016 12:32 AM (in response to Siang Li Chua)

Hi Siang,

Based on above it's hard to tell. Can you share your workbook with the community.
For sure a lot members will help out if they can examine your workbook.
Like Show 0 Likes(0)

Actions
2. Re: Quick Calculation: Percentage of Difference from First

Walt Reed Nov 29, 2016 7:42 AM (in response to Siang Li Chua)
Hey Siang,
You're going to want to change the "Calculate the difference along" from "Table (Across)" to "Specific Dimensions". Not having access to your dataset, I created a similar table using the Sample Superstore data. Since it looks like you have an older version of Tableau, check out the screenshots:

Let me know if this works for you.

Cheers,
Walt

Percent Difference from First.twb 195.9 KB
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community

Quick Calculation: Percentage of Difference from First

1. Re: Quick Calculation: Percentage of Difference from First

2. Re: Quick Calculation: Percentage of Difference from First

Actions

More Like This