Right Click 2017 Column and Select Hide
As I mentioned, I do not want to hide the column manually as there are around 70 sheet to perform that action.
I am looking for calculated fields/other options where the column gets dynamically hidden in such cases
See example below i have (2) years, 2014 & 2015.
I want to get the difference between Q1 2014 figs from Q1 2015.
I created the following Calc:
Then the following for the % increase
Bring Measure Values to shelf and the 2 calcs and you will get table below.
This essentially gets the result you want however i'm not sure how you can reference a prior year if you're focus is ONLY the current year on the table.
As far as i know you do need to hide the previous year from the table to get the result below:
If anyone knows how to do the requested i'm definitely interested also
Please share the tableau workbook to understand better
Please share your workbook as twbx.