I would like a chart in a dashboard show the sum value in the summary line of a report
I have reached the max on a sheet leaving me to archive it and creating a new one.
Once I have done this, I want both sheets on my report and from there sum the values and then portray that value in a chart on a dashboard. Currently the dashboard shows the chart from each sheet, not the sum of both sheets.
How can I get the sum to show?