Hi Wuhao,
We can achieve this via a custom Excel report
Refer my below blog to generate the excel report via java action
https://www.indiumsoftware.com/blog/a-comprehensive-guide-to-creating-high-performance-excel-generation/
You can tweak the java action little to show the sum of column in excel