Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
v_kash
Starting Member
45 Posts |
 Posted - 2009-12-08 : 12:15:43
|
| hello, i have a SSRS report, with three groups in it (lets call it group 1, group 2, and group 3). I have a subtotal for each group, and a grand total at the bottom (group 1 + group 2 + group 3). However, i want to add another row, that gives me a subtotal for just GROUP 1 and GROUP 2. how do i do this? |
|
|
v_kash
Starting Member
45 Posts |
Posted - 2009-12-08 : 13:29:57
|
| = Sum(iif(Fields!DIST_GROUP.Value = "1" or Fields!DIST_GROUP.Value = "2",Fields!LYSales.Value, Nothing))thats how you do it. i had trouble getting it to work in the table footer for some reason. |
 |
|
|
|
|
|
GROUPING PROBLEM - HELP NEEDED