addinG ONLY TWO ROWS OF 4 ROWS IN SSRS

Question

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

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

Jason Selburg SSC-Insane Points: 24641 More actions · Answer 1

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.

sql_reporting SSC Veteran Points: 299 More actions · Answer 2

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

bulbanos Ten Centuries Points: 1049 More actions · Answer 3

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.