4 Replies Latest reply: Dec 31, 2013 12:06 PM by Travis Touroo RSS

    Combo chart display growth

      Hi,

       

      I have a combo chart. X axis are quarters of year, Q1 2012, Q2 2012 etc... Y axis are sum(Revenue).

       

      I would like to add a dimension that is the growth from one quarter over the next. Calculation is not possible for the first quarter in the data. then formula would be LAST(Sum(revenue))/FIRST(Sum(Revenue)). how can i refer to previous quarter of year in my expression ? how can i check if data for the last quarter of year are available ?

       

      Regards