Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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