2 Replies Latest reply on Feb 7, 2019 5:48 AM by Yogish b

    How to show variance of latest two years when there is 20 years of data?

    Yogish b

      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