3 Replies Latest reply: May 16, 2018 6:08 AM by Silambarasan Manickam RSS

    Rolling sum in quarter

    anusha hegde

      Hi Everyone,

       

      There is a filter called period which contains all the months.

       

      The requirement is

       

      For any year,

       

      For quarter 1,

      If Period = Jan is seleted, then sum (Sales) for Jan should be diplayed.

      If Period = Feb is selected, then sum(Sales) for Jan + Feb should be displayed.

      If Period= Mar is selected, then sum(Sales) for Jan + Feb + Mar should be displayed.

       

      For quarter 2,

      If period = April is selected, then sum(Sales) for Apr should be displayed.

      If period = May is selected, then sum(Sales) for Apr + May should be displayed.

      If period = Jun is selected, then sum(Sales) for Apr + May + June should be displayed

       

      and so on.

       

      Please help me to know how can I do this.

       

      Thanks in advance,

      Anusha.