Code: SQL
SELECT GL_ID, GL_Name_VC,
SELECT Period_TI FROM <tablename> WHERE Period_TI = 1 AS Period_01,
SELECT Period_TI FROM <tablename> WHERE Period_TI = 1 AS Period_02,
(Period_01 + Period_02) AS Total_YTD
FROM <tablename>
GROUP BY GL_ID
Now multiplying the percentage will give you the totla row.