--Total Admissions \ Cinema     
SELECT Cinema_DisplayName, 
       Sum(Admissions) AS Admissions,
       Sum(CoolAdmissions) AS CoolAdmissions
	--  Admissions * 100.0 / Sum(Admissions) over () as percentage
FROM ZZ_vwpProgressBoard
GROUP BY Cinema_DisplayName
ORDER BY MAX(Cinema_Order)

 

 
--Total Admissions \ Cinema     
SELECT Cinema_DisplayName, 
       Sum(Admissions) AS Admissions,
       Sum(CoolAdmissions) AS CoolAdmissions,
	Sum(Admissions+CoolAdmissions) * 100.0 / Sum(Admissions) over () as percentage
FROM ZZ_vwpProgressBoard
GROUP BY Cinema_DisplayName,Admissions,CoolAdmissions
ORDER BY MAX(Cinema_Order)

quote:

---

Originally posted by sapator

Hi. I have this query:

--Total Admissions \ Cinema     
SELECT Cinema_DisplayName, 
       Sum(Admissions) AS Admissions,
       Sum(CoolAdmissions) AS CoolAdmissions
	--  Admissions * 100.0 / Sum(Admissions) over () as percentage
FROM ZZ_vwpProgressBoard
GROUP BY Cinema_DisplayName
ORDER BY MAX(Cinema_Order)

 

however if it try it like below it will expand the admissions and cooladmissions rows. something that i want to avoid.

 
--Total Admissions \ Cinema     
SELECT Cinema_DisplayName, 
       Sum(Admissions) AS Admissions,
       Sum(CoolAdmissions) AS CoolAdmissions,
	Sum(Admissions+CoolAdmissions) * 100.0 / Sum(Admissions+CoolAdmissions) over () as percentage
FROM ZZ_vwpProgressBoard
GROUP BY Cinema_DisplayName,Admissions,CoolAdmissions
ORDER BY MAX(Cinema_Order)

---