I am looking for a way to take an existing bar chart and modify it to show one city bar from the group level and one total for all cities bar from the report footer section for comparison purposes.

Currently the chart shows a dozen city bars only at the group level with the totals for all cities in the report footer section below the city groups.

Thanks for your help.