2 Replies Latest reply: Apr 19, 2013 4:06 AM by kmegzari RSS

    problem with accumulate by month

      Hello Experts,

       

      I need a help to resolve this problem

       

       

      I have in Input in a pivot table

       

      Applications Servers        Months

      A01                             S1                Octobre-2012

      A11                             S1                Octobre-2012

      A02                             S2                November-2012

      A03                             S4                December-2012

      A04                             S2                January-2013

      A14                             S1                January-2013

      A03                             S1                February-2013    

      A01                             S2                March-2013

       

       

      I have to accumulate a number of distinct “applications” by month with a condition that is not accumulate “applications” if exist in previous month.

      The expression I’m using is

      RangeSum(Above(Count (distinct([Applications])),0,RowNo()))

       

      Result provided

      Months                                            Cumulated different Numbers Of Applications by month                                               

      Octobre-2012                                        2  

      November-2012                                    3  

      December-2012                                    4  

      January-2013                                         6                                     

      February-2013                                      7    (a problem for me because A03 exist in December-2012)                                                                                                                

      March-2013                                           8    (a problem for me because A03 exist in October-2012)

       

       

      And I want to have this result

       

       

      Months                                            Cumulated different Numbers Of Applications by month                                               

      Octobre-2012                                        2  

      November-2012                                    3  

      December-2012                                    4   

      January-2013                                         6   

      February-2013                                      6    (because A03 exist in December-2012)                                                                                                                

      March-2013                                           6    (because A01 exist in Octobre-2012)

       

      Thank you in advance for tour help.