SSRS – SUM based on condition

In this article , let us see an example on how to SUM based on condition in SSRS tablix report . Consider below query is my report dataset :DECLARE @tmp TABLE (Code VARCHAR(10),Level1 INT,Level2 INT)INSERT @tmp SELECT ‘CHN’,5,10INSERT @tmp SELECT ‘KOL’,5,15INSERT @tmp SELECT ‘IND’,10,25INSERT @tmp SELECT ‘NY’,5,10INSERT @tmp SELECT ‘TX’,5,15INSERT @tmp SELECT ‘US’,10,25SELECT * FROM…

Details