Hi, I have been researching and unfortunately it is not so clear to me to be able to move from rows to columns or maybe it does not have the same format as in the examples I'm doing this query to enter it into a KENDO GRID table, This is my query:
SELECT ANO AS YEAR,
SUM(VENTAS) VENTAS,
SUM(DEVOLUCIONES) DEVOLUCIONES,
SUM(TOTALI) TOTALI,
(((SUM(VENTAS)/SUM(TOTALI)))*100) VERTIALVENTAS,
((SUM(VENTAS))/(SELECT SUM(VENTAS) FROM EDORESULTADO WHERE ANO=YEAR-1)-1)*100 HORIZONTALVENTAS,
((SUM(DEVOLUCIONES)/SUM(TOTALI)))*100) VERTIALDEVOLUCIONES,
((SUM(DEVOLUCIONES))/(SELECT SUM(DEVOLUCIONES) FROM EDORESULTADO WHERE ANO=YEAR-1)-1)*100 HORIZONTALDEVOLUCIONES,
(((SUM(TOTALI)/SUM(TOTALI)))*100) VERTIALTOTALI,
((SUM(TOTALI))/(SELECT SUM(TOTALI) FROM EDORESULTADO WHERE ANO=YEAR-1)-1)*100 HORIZONTALTOTALI
FROM EDORESULTADO
GROUP BY ANO
I tried to do it but I could only get this and then I do not know what to do anymore. GREETINGS
SELECT
SUM(CASE WHEN ANO="2012" THEN VENTAS ELSE 0 END) "2012",
SUM(CASE WHEN ANO="2013" THEN VENTAS ELSE 0 END) "2013",
SUM(CASE WHEN ANO="2014" THEN VENTAS ELSE 0 END) "2014",
SUM(CASE WHEN ANO="2015" THEN VENTAS ELSE 0 END) "2015",
SUM(CASE WHEN ANO="2016" THEN VENTAS ELSE 0 END) "2016",
SUM(CASE WHEN ANO="2017" THEN VENTAS ELSE 0 END) "2017",
SUM(CASE WHEN ANO="2018" THEN VENTAS ELSE 0 END) "2018"
FROM EDORESULTADO