11 Replies Latest reply on Aug 2, 2017 1:54 AM by Vincent C

    Latest Quarter sales Difference

    habibulla.shaik

      Hi,

      I hope you people are doing good. I have a requirement that is, I am having table like below and I want the difference between latest quarter in every year.

      Eg: 2010 Q4- 2011 Q4. I am able to get all the Q4 values but I want the difference between 2012 Q4 o 2013 Q1.

      May I know the possible cases in this.

      Thanks in advance.

       

       

      YearQuarterSales
      2010Q1100
      2010Q2150
      2010Q3251
      2010Q4260
      2011Q1154
      2011Q2254
      2011Q3352
      2011Q4450
      2012Q1555
      2012Q2412
      2012Q3325
      2012Q4102
      2013Q13256