Dynamic View - Show Totals

DaveD

We often use Dynamic View for doing project reviews. We use dynamic view versus report because updates are made during the meeting. We would like to be able to show totals. Example: The dynamic view shows a list of cost savings projects. The filter on the review allow you to display one site at a time. That site reviews their programs, then the filter is changed and the next site reviews theirs. We would like to have the total value of the programs for the site shown. This currently has to be done by applying a similar filter on the main sheet to be able to calculate the total.