Refer the query.
DECLARE @Test AS TABLE (Station VARCHAR(100),[Types] VARCHAR(100),Category VARCHAR(100),Amount INT)
INSERT INTO @Test VALUES('KIWAAWO HEALTH CENTRE','INCOME','GPHC',34000)
INSERT INTO @Test VALUES('KIWAAWO HEALTH CENTRE','EXPENSES','FOOD',4000)
INSERT INTO @Test VALUES('KIWAAWO HEALTH CENTRE','INCOME','SALES',50000)
DECLARE @Income INT, @Expenses INT, @Profit INT
SELECT @Income = SUM(Amount) FROM @Test WHERE [Types] = 'INCOME'
SELECT @Expenses = SUM(Amount) FROM @Test WHERE [Types] = 'EXPENSES'
SELECT @Income 'Income', @Expenses 'Expences', @Income - @Expenses 'Profit'
Output
Income Expences Profit
84000 4000 80000
Then use the result to display in the report.
