7 Replies Latest reply on Nov 15, 2017 1:11 AM by Chadi Atie

# How to have a percentage of difference on a difference of total for 3 years?

Hello Guys,

I have this data, instead of showing the exact percentage for the whole years, I need just to show the percentage of the 1st year, and on the next years I want to show the difference of the percentage of the previous year

Example for Belgium:

201520162017Grand Total
84.89%+7.28%-7.78%Keep as it is or put +3.20%

I have attached the workbook.

Thank you guys

• ###### 1. Re: How to have a percentage of difference on a difference of total for 3 years?

Create the below calc with a measure of your interest.

Set the Table calc scope as :

Let me know if this helps.

~Tushar

• ###### 2. Re: How to have a percentage of difference on a difference of total for 3 years?

Unfortunately no, because in my table I have values from a calculations already and don't know how to use it in this calculation

If you could into my workbook you may know what I mean.

Thanks anyway

• ###### 3. Re: How to have a percentage of difference on a difference of total for 3 years?

I tested it against your data. Store your current calc as a separate field.

Then modify the formula.

View:

cheers,

~Tushar

1 of 1 people found this helpful
• ###### 4. Re: How to have a percentage of difference on a difference of total for 3 years?

Thank you Tushar,

• ###### 5. Re: How to have a percentage of difference on a difference of total for 3 years?

Hi,

~Tushar

1 of 1 people found this helpful
• ###### 6. Re: How to have a percentage of difference on a difference of total for 3 years?

Could you please upload this as an older version of Tableau? I am not able to open the workbook to check the solution.

• ###### 7. Re: How to have a percentage of difference on a difference of total for 3 years?

Hello Laura,

If you want, you can post a new discussion in the forum and ping me there so I can give you the solution.

It could be helpful if you would also upload your own workbook, so I can do it directly on yours.

Regards,