1 Reply Latest reply: May 19, 2017 12:00 PM by Sunny Talwar RSS

    histogramme expression

    souad ouertani

      Good morning

      I have a histogram, include the realization trend per month per agency, with the realization for example of February month is the sum between February + January,

       

      i used this expresion fo table , i need to modify this expression because this expression work with selection month and year

      sum({<YEAR = {$(=Max(YEAR))}, MONTH, MONTHNUM = {"<= $(=MAX(MONTHNUM))"} ,REAL_CAPITALCLIENT.CONQUETE={"OUI"}>}REAL_CAPITALCLIENT.NOMBRE_CLIENT)