2 Replies Latest reply on Jun 29, 2016 5:11 AM by Akshay Pallerla

    Cumulative sum of a field based on a selection in parameter

    Akshay Pallerla

      Month - Year

      Exclusive Count

      Cumulative Sum

      Mar-16

      6

      97

      Apr-16

      5

      102

      May-16

      9

      111

      Jun-16

      63

      143

       

       

       

      Param Filter - Open_dt

      Expected Count

       

      Mar-16

      97

       

      Apr-16

      102

       

      May-16

      111

       


      I have a scenario like this:

       

      I have a system which would store the tickets that are raised.

      Exclusive Count column above shows count of tickets generated exclusively in that month.

      When a ticket is generated we have two fields --> Open_dt and Close_Dt. That count of 6 shows still 6 tickets are yet to be closed meaning close_Dt is null.

      That cumulative sum above shows the count of tickets are yet to be resolved since mar-16 starting Jan 2015.

       

      The actual requirement is:

       

      I have a parameter which would filter data in the report area.

      If I select Mar-16, it should show the count of open tickets as not just 6, but 97 , meaning it should consider open tickets till mar16 since jan15.

      If I select Apr-16, it should show the count as 102 not just 5.

       

      Any help would be greatly appreciated !