3 Replies Latest reply: May 30, 2012 5:32 PM by alejandro hernández RSS

    Shows the total of sales to the end of each month

    Felipe Ruiz

      Hi!

       

      I need a chart that shows the total of sales to the end of each month. I used an island calendar with the month as a dimension, how is the set analisys in this case ??

       

      I used this set analysis

       

      =(SUM({$<FechaRegistroCar = { '<=$(=MonthEnd('$(=Max(AñoCartera))-$(=MesCartera)-1'))' } >} ValorCartera ))

       

      but always shows the sales of the last month.

       

       

      Thanks!