0 Replies Latest reply: Sep 13, 2018 3:36 PM by kevin santos RSS

    TOP graph

    kevin santos

      I need to bring the sum of the sale of the 25 biggest products in the graph I have below a formula that me in the table that value, but I need to put in the graph that with the dimension of year-month and is not working.


      (
      sum(

        aggr(

        if(rank(sum({<TIPO={'VENTA NETA FINANCEIRA'}>} VALOR))<= 25
        sum({<TIPO={'VENTA NETA FINANCEIRA'}>} VALOR))

        ,[DESCRIPCIÓN]

        )

      ))/1000