How to exclude hidden row vaue from total value SSRS
- by Annmarie
I have an SSRS project and I want to exclude a row that I have hidden from the total.
I have hidden the row based on an expression on the row visibility, where the row is hidden if:
=IIF(IIF(ReportItems!CUST_CNT2.Value = 0, 0, ReportItems!Total_Contribution5.Value / IIF(ReportItems!CUST_CNT2.Value = 0, 1, ReportItems!CUST_CNT2.Value)) > 0, True, False)
So basically the column totals for the report just total up all rows including this above row that I have hidden, and I need the total to exclude this row.
Any ideas?