6 Replies Latest reply on Sep 11, 2018 5:06 AM by Brijesh Ramani

# How to calculate the difference between two years in tableau, when Year is a dimension with multiple values (for years)

• ###### 1. Re: How to calculate the difference between two years in tableau, when Year is a dimension with multiple values (for years)

Hi,

right click on your measure (Value MD)

Please refer below image for reference.

If you want in % change then click on Year over Year Growth else Difference.

Best

Suman

1 of 1 people found this helpful
• ###### 2. Re: How to calculate the difference between two years in tableau, when Year is a dimension with multiple values (for years)

Thanks Suman,

But, I wanted the actual values also to get displayed with the difference. Further, I have multiple year data along with 2016 and 2017. And I wanted to give the option of choosing the year also to calculate the difference.

• ###### 3. Re: How to calculate the difference between two years in tableau, when Year is a dimension with multiple values (for years)

Hi Brijesh,

You can use date filter from there users can choose the year. see below image

I have dragged the date dimension in filter and selected year. Now right click on filter (Right Side) click on customize--> Show Apply Button

1 of 1 people found this helpful
• ###### 4. Re: How to calculate the difference between two years in tableau, when Year is a dimension with multiple values (for years)

Thanks a lot Suman,

This almost solves the issue, but tableau is allocating a year to the difference instead of a separate value

• ###### 5. Re: How to calculate the difference between two years in tableau, when Year is a dimension with multiple values (for years)

Yeah, It gives difference only not original value with it.

but at least you solved major problem.

Best

Suman

1 of 1 people found this helpful
• ###### 6. Re: How to calculate the difference between two years in tableau, when Year is a dimension with multiple values (for years)

Hi Suman,

Thanks a lot for your help