🔒 Closed Get percentage of column total mysql

[PHC-SUIYOBI]

Good day po, baka may nakakaalam po jan kung paano kuhanin yung percentage of column total po based sa sql statement ko po

SELECT Product, ROUND(SUM(Revenue),2) AS Revenue
FROM dataset
GROUP BY Product;

then ito yung output nung sql statement ko,


Then ang gusto ko po sana is ganito yung magiging output niya,

from this, (ni-"show values as" ko po siya as "%of Column Total" po)


to this po,


Sana may makatulong po, maraming salamat po.

 

[dee-u]

Try mo ito kung gagana:

SELECT Product, ROUND(SUM(Revenue),2)*100/t.s AS Revenue
FROM dataset
GROUP BY Product
CROSS JOIN (SELECT SUM(Revenue) AS s FROM dataset) t

 

[vhin le]

Can you at least provide SQL dump copy so that we could try from our local pc in order to provide further assistance. Thanks!

 

[PHC-SUIYOBI]

Try mo ito kung gagana:

SELECT Product, ROUND(SUM(Revenue),2)*100/t.s AS Revenue
FROM dataset
GROUP BY Product
CROSS JOIN (SELECT SUM(Revenue) AS s FROM dataset) t

fix na sir, maraming salamat po,