4 Replies Latest reply: Jan 12, 2018 6:59 AM by Amit Saini RSS

    Logic Help !!!

    Amit Saini

      Hi Folks,

       

      I'm calling below dim and exp in a line chart:

       

      Dim :

      =if(isnull(GetFieldSelections(Week))=0,

      if(Week<=SubField(GetFieldSelections(Week),',',-1),Week),

      if(isnull(GetFieldSelections(Month))=0,

      Week<=aggr(max(Week),$Field),

      if(Week<=53,Week)))

       

      Exp:

      rangesum(above((Count(DISTINCT{<Month,Year={'2017'},Week,

      Product_Group_N={'CVS'},

      Complaint_Classification={'0-km Complaint'},Complaint_Type_Description={'Supplier'}>} NRQNR)),0,RowNo()))

       

       

      Now when I'm selecting any week lets say in below case 7 , it should show all the prior weeks including 7 , which is working absolutely fine. See below:

       

       

      The same concept should work for Month also, when I'm selecting Feb , it should show me all weeks data from Jan until selected Feb , but currently it's not working this way.

       

       

      Any suggestions???

       

      Regards,

      AS