I have a column called "Total" in SQL reporting servece report. When generating report I'm hiding some rows accoring to some formula, But calculating the total that hidden rows values also calculating. Can I know how to exclude hidden row value from total value?
Here are some ideas: Could you use the same conditions in the expression for the total so it's the total of the rows that are hidden? Could you apply the conditions in the query so those rows are not returned, which would make the whole report part easy?