4 Replies Latest reply: May 29, 2015 3:15 PM by Claus Fuss RSS

    Set Analysis Filter

    Claus Fuss

      Rigth now I'm using a KPI to calculate the Sales Amount for last year and current month like this

      SUM({$<Anio={"$(=$(vAnioAnt))"},Mes={"$(=MONTH(TODAY()))"}>}TotalVta)

      Where vAnioAnt is a variable containing las year (2014),   but right now I need that the KPI calculate the total sales amount for last year but from January to the current Month.  Please help.  Anio is the field containing the Year, Mes is the field containing Month and TotalVta, is the field containing total sales.

      Also I need something alike but calculate the total sales from 1 year from now, for example today form may28, 2014 to may 28, 2015, the field containing date for transaction is fecha.

       

       

      Thanks in advance