Add text box with Total to chart

[Angela]

I have a Pareto chart displaying totals for each category. I would like to
add a text box at the bottom of the chart that displays the Total Sum for all
categories. The chart is based on a query, but the chart is on a report that
does not have a datasource. If I based the report on the same query as the
chart, then I can add a "sumof" textbox based on the report's query, but then
(since the chart is in the detail portion of the report) I get 900 pages of
the same chart. I could move the chart to the footer section of the report
and maybe get only one chart, but is there an eaiser way to create the text
box on the chart itself?

 

[Angela]

Never mind, I figured it out. I created another query that sums the first
query, and based the report on the new query.