How to export the sum row from the table to Excel?

For the table on the website, I utilized the aggregate function to generate a sum row. However when I used a Export to Excel button, it only exported the part of the table that didn't include the sum row. Does anyone know how to solve this?
1 answers

Hi Wuhao, 


We can achieve this via a custom Excel report 


Refer my below blog to generate the excel report via java action


You can tweak the java action little to show the sum of column in excel