1 Reply Latest reply on Sep 23, 2016 3:59 PM by diego.medrano

    Current Year Revenue vs Prior Yr Revenue vs 2 years ago Revenue

    Michael Franz

      I am trying to recreate the following table.  I do have a Dimension (date type) that is called Reporting Month... 

      and I need Current Year to be "changeable"... Mainly when we go into the next year. Because in the middle of January 2017 there will be no data until the end of the month so the manager will want it flipped back to 2016.    

       

       

      Employee  NameCurrent Year (Total)Prior Year (Total)Dollar Change (Total)Percent Change Current Year. (Total)2 Year Ago (Total)Dollar Change (Total)Percent Change Current Year.. (Total)3 Year Ago (Total)Dollar Change Three (Total)Percent Change