When you view the query, the total is given on the right side of the report, but when you export the report the total is not included in the export.