2 Replies Latest reply on Jan 23, 2019 7:53 PM by Sourav Ghosh

    percentange chage compared to previous year

    Sourav Ghosh

      Hi everyone,

       

      For one of my problem, I was referring the following blog:

       

      https://www.thedataschool.co.uk/gwilym-lockwood/i-like-big-numbers-i-cannot-lie-make-numbers-pop-kpi-dashboards-tableau/…

       

      However, the thing which is yet to resolve-

       

      How to obtain the % change value compared to a selected year ?

       

      To be specific- in the example, the latest year is 2015 and the comparison is that of 2014.

       

      How to execute the following - if I select year = 2012 , it will give the comparison with 2011.

       

      Simply adding a filter is not working as when I filter year= 2012, 2011 data goes filtered out and it's showing blank as percentage change.

       

      Any lead will be great help.

       

      Thanks-

      Sourav