I have a report that shows each row with a sum broken out by line item. I.E.:
Category & Field & Total Count
Cat A | A | 50
Cat A | B | 100
Cat B | C | 50
Cat B | D | 25
==========================
Cat A Total: 150
Cat B Total: 75
All Total: 225

Each row total is listed as this: sum(iif(Fields!Field.Value = “A”,1,0)), so there is a total of 50 “A”s. And so forth. The total per category is sum(iif(Fields!Category.Value = “A”,1,0)).
Then for the total, it is sum(iif(Fields!Category.Value = “A”,1,0)) + Sum(iif(Fields!Category.Value = “B”, 1, 0)). This all works fine. However, I have a parameter to select the field(s) needed. Is there a way to exclude the total count of a field from the totals? So if someone selects all fields in the parameter except “A”, I would want to see the following:
Category & Field & Total Count
Cat A | B | 100
Cat B | C | 50
Cat B | D | 25
==========================**
Cat A Total: 100
Cat B Total: 75
All Total: 175

Is this possible with some fancy footwork?

I did try some different steps with the row visibility settings since I do not want to show the rows that are not selected in the field parameter, but not sure how to incorporate. Here is the visibility setting at the row level:
iif(
InStr(Join(Parameters!Category.Label,”,”),”Cat A”) > 0
and InStr(Join(Parameters!Field.Label,”,”),”A”) > 0
,false,true)