export excel report

Hello all,

Please help me to solve this problem. I have designed excel report but when i exporting the report , total pick the last amount .

How to calculate the all line amount in Total?

use the calcsum(field) function.