I have 20 Years(1999 to 2019) of data and to be displayed all in one sheet. but when i hover on any of the year - the variance to be shown only for the latest 2 years.
i.e., when i hover on 2005 then the variance is between 2005-2004 only and when i hover on 2006 then variance is between 2006-2005 only.
Pls. help me.. Thanks
Without seeing your sample data or workbook, I use super store as example attached.
Below is the screenshot of result
Hope this helps
Thanks Zhang its working
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...