2 Replies Latest reply: Jul 13, 2015 3:32 AM by ankit bisht RSS

    Previous Year, YoY Analysis ( Year to Year )

    Amith Murali

      Hi guys,

       

      i have a problem. i want to compare YOY revenue in my dashboard. but when i do the comparison, for example, if i have data till may of 2015. it is comparing with the entire revenue for 2014. i dont want like that. i want to compare till 2014 may only when i comparing 2015 may. i am sending you the table and code which i have used. please help me.

       

      DateRevenue
      12-jan-2014123234
      3-feb-2014234234
             :      :
            :      :

      1-jan-2015

      1212313
      1-feb-2015334341
      1-mar-2015423424
      1-april-20153434321
      1-may-201523432423

       

      "=sum({<Year = {$(=max(Year))}>}(Revenue))/sum({<Year = {$(=max(Year)-1)}>}(Revenue))"

       

      I am using Universal Calender for the tables.