Hi,
Got it to work. Here is the other table:
CREATE TABLE [dbo].[tbl_Calculation](
[CalcID] [int] IDENTITY(1,1) NOT NULL,
[CalcKPI_ID] [int] NOT NULL,
[FK_KPI_ID] [int] NOT NULL,
[KPI_Operation] [varchar](50) NOT NULL
)
Then:
WITH Separated_Info(Period, TopLine, BottomLine) AS
(SELECT Period,
CASE KPI_Operation WHEN 'TOP' THEN Table_1.Score END AS TopLine
,CASE KPI_Operation WHEN 'BOTTOM' THEN Table_1.Score END AS BottomLine
FROM Table_1 INNER JOIN
tbl_Calculation ON Table_1.FK_ID = tbl_Calculation.FK_KPI_ID
)
SELECT SUM(TopLine)/ Sum(BottomLine)
FROM Separated_Info
GROUP BY Period
Thanks for the help guys.