2 Replies Latest reply: Jan 23, 2018 12:09 PM by Luis Carmona Martínez RSS

    GRAPH Year over Year Growth per Product Category

    Luis Carmona Martínez

      Hi,

       

      I was able to get the year over last year growth using the FUNCTION above, and that worked properly in a Graph, that only have DIMENSION year and the Following Measure

       

      sum(

      {<

      [YEAR_INVOICE]={">2010"}-{"$(=Max([YEAR_INVOICE]))"}

      >}

      [SALES])

      /

      Above(sum(

      {<

      [YEAR_INVOICE]={">2010"}-{"$(=Max([YEAR_INVOICE]))"}

      >}

      [SALES]))

      -1

       

      BUT when I ad a new dimension in the GRAPH, to split the information in Product_Categories, then does not work. I guess this formula using ABOVE does not make sense then.

       

      ¿Any suggestions?