• 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.