Hello,
Is there a way to display 2017 information compared vs 2016, without showing 2016 columns? (It might sound confusing, so please take a look at the example below).
Sales 2016 | Dif vs prev year | Sales 2017 | Dif vs prev year |
---|---|---|---|
10 | 12 | 2 | |
8 | 6 | -2 | |
15 | 15 | 0 |
I want to see this:
Sales 2017 |
| |
---|---|---|
12 | 2 | |
6 | -2 | |
15 | 0 |
If I use filter I will not be able to obtain the dif vs previous year (because I would not have access to 2016 data in the table when displaying only 2017)
If I use Hide column I will need to alter my dashboard each year or month, depending on what I need to display...
Any suggestions for this case?
Thank you,
Hi Cecilia,
This is FAQ and this link helps.
Filtering the View Without Filtering Underlying Data | Tableau Software
Thanks,
Shin