In an existing ssrs 2008 report, I want to add final report totals. I want the total line to be the final total for all the lines displayed on the report. Right now when I right click on the calendarnames and select 'add total', I see the totals for all the data just brought into the report. I just want to see the totals for only the calendar names that have been selected.
For example, if I have the calendarnames of Adams Elem, Gross High, and Josylyn Middle School, I only want the totals to be for those 3 schools. I do not want to see the totals for all the schools in the school district. Can you tell me what I can do to solve my problem? Here is a picture of what my ssrs report looks like in design view: