Post reply

Sum subset in group

  • October 10, 2014 at 3:02 pm

    #294110

    I'm not sure how to do this:

    column1 column2

    1 5

    2 7

    1 1

    Total (I want the total of column2 where column1 = 1)

    I'm sure there's a way to do it?

    Anyone?

  • October 10, 2014 at 4:52 pm

    #1751764

    SELECT column1, sum (column2)

    FROM <yourtable>

    WHERE column1=1

    GROUP BY column1

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

  • October 10, 2014 at 5:04 pm

    #1751765

    For SSRS, it should be something like this:

    =Sum(IIF(Fields!column1.Value = 1, column2, 0))

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • October 10, 2014 at 7:41 pm

    #1751776

    Alan.B (10/10/2014)

    SELECT column1, sum (column2)

    FROM <yourtable>

    WHERE column1=1

    GROUP BY column1

    How embarrassing, I did not realize, at the time I posted this, that this was an SSRS forum (smacking forehead).

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply