6 Replies Latest reply: Jul 30, 2016 4:32 AM by Antonio Mancini RSS

    Problem with Aggr & Set Analysis

    Enrique Colomer

      Hi,

      I need to obtain in a  table with (Ventas) Sales >0 in the Actual Year and the same for the last Year and but my expression don't work.

      • count({<Año={$(AñoActual)}, Mes={'<=$(MesActual)'}>} distinct Cliente)
      • Sum(if(Aggr(Sum({<Año={$(AñoActual)}, Mes={'<=$(MesActual)'}>} imVentaTAM), Cliente)>0, 1,0) )

      p_ctes.pngthe number of Customer