6 Replies Latest reply: Oct 23, 2014 1:41 AM by Tresesco B RSS

    Getting Previous

      Hi Guys,

       

      Just want to ask if how can I do this using set analysis:

       

      Year20132014
      Qtr-YearFormula1Formula2Formula1Formula2Formula1Formula2Formula1Formula2Formula1Formula2Formula1Formula2
      TypeCustomerRegion1Q131Q132Q132Q133Q133Q133Q133Q134Q134Q131Q142Q14
      RevAR112310543512311235435213123232132343223
      BR112312034534123122133453421321323213234223
      CR212310345123123345123122312323123122342312323
      DR223530213235321321312321323212323432232

       

      I have here a table. Formula1 is just a sum of Revenue, however for Formula2, I need to get the PREVIOUS sum of revenue.

       

      ex for 2Q13:

       

      Formula1 : sum(Rev)

      Formula2 = Formula1 of the last quarter

       

      I do not want to use the before() function. Is it possible to be achieve using set analysis only?

       

      Thanks,

      Lyn