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