Post reply

addinG ONLY TWO ROWS OF 4 ROWS IN SSRS

  • February 15, 2012 at 12:27 pm

    #268436

    Hi when i put the table IN SSRS i get in the below format

    Col1 Col2 Col3

    CAT1 2 3

    cAT2 3 4

    CAT3 3 5

    cAT4 3 3

    CAN I GET SUM ONLY FOR FIRST TWO ROWS...CAT1, CAT2

  • February 15, 2012 at 12:50 pm

    #1447508

    You might look up SUMIF in BOL

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg

  • February 15, 2012 at 2:11 pm

    #1447548

    Jason Selburg (2/15/2012)

    You might look up SUMIF in BOL

    I ALSO WANT THE SUM OF THAT 2 ROWS AFTER THE 2 ROWS I NEED A ROW SPECIFING SUM ROW AND COL3 AND COL4 AS USUAL...

    CAT1

    CAT2

    SUM(CAT1&CAT2)

    CAT3

    CAT4

  • February 17, 2012 at 7:22 am

    #1448486

    Create a group with an Expression for Grouping. Use something in the lines of

    iif(Cat="CatA" or Cat="CatB", "Group1","Group2")

    Create totals for your groups.

    That will however add a Total for Group2 as well. You might be able to hide it conditionnally.


    My LinkedIn profile

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

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