5 Replies Latest reply on Dec 4, 2016 11:39 PM by Sanket Kelkar

    Get data for previous quarter

    Sanket Kelkar

      Hi All,

      I am looking for a solution on below scenario -

      I have 2 filters Year and Quarter. For a selected year and a selected quarter, I need to display sum(sales) for selected quarter, previous quarter of same year and selected quarter of previous year.

       

      Eg. If I select year = 2013 and quarter = Q3, I need sum(sales) for following details -

      2013 Q3

      2013 Q2

      2012 Q3

       

      I have tried many ways of getting it in this format but did not find a solution. Can someone please help me ?

       

      TIA,

      Sanket.