Percentage of sales for the current month

Question

Percentage of sales for the current month

Navigation

#1 by (1 votes)
#2 by (0 votes)

0

I want to get the percentage of sales for the month of the current year. In other words, I sum the total sales of the month of each month and I divide them by the total sales of the year.

SELECT
    *,
    sum(total_venta) as total_venta 
FROM compra 
GROUP BY MONTH(fecha_factura) /
    (SELECT
         sum(total_venta) * 100 as porcentaje
     FROM compra)

But it's not coming out.

mysql phpmyadmin

asked by Magnolia Eve 01.10.2017 в 02:11

source

2 answers

table with a tr of a single td Import values from a Dictionary to my Python variables

score 1 · Answer 1

I found this example just check the names of your table and columns, modify these in the following query.

applying OVER () to get summary total and percent on base.

SELECT   MONTH = MONTH(OrderDate), SUM(TotalDue) AS SalesByMonth, 
         100.0 * ((SUM(TotalDue)) / (SUM(SUM(TotalDue)) 
                                       OVER())) AS PctSalesByMonth 
FROM     AdventureWorks2008.Sales.SalesOrderHeader 
WHERE    YEAR(OrderDate) = 2003 
GROUP BY MONTH(OrderDate) 
ORDER BY MONTH;

Result

score 0 · Answer 2

Assuming that your query is in mysql, you can do the query by doing the sum and the subquery directly within the main query. You can use the following code:

SELECT 
    *, 
    sum(total_venta) as total_venta, 
    sum(idTipoProducto)/(SELECT SUM(total_venta) FROM compra ) * 100 as porcentaje_venta 
FROM compra 
GROUP BY MONTH(fecha_factura);