Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Generated Excel File doesn't display "Grand Total"



A Report Definition which uses Summary Functions have a Totals Row at the bottom of the Report which is called the "Grand Total". When exporting to PDF this row is displayed, but if we export it to Excel, it does not display the Grand Total row.

Error Messages

No errors, just the Grand Total row is missing in the Excel file.

Steps to Reproduce

1. Create a Report Definition with summary functions
2. Run the report and verify whether the "Grand Total" is displayed at the bottom of the report.
3. Export to Excel, open in Excel and see.

Root Cause

The customer expectes the grand total value to be displayed on excel sheet,when clicking on export to excel button.


This is the expected behaviour because the Export to excel feature provided by PRPC is to provide a manipulatable spreadsheet and its not the replica of the report generated on the report browser.
Suggest Edit

Published January 31, 2016 - Updated October 8, 2020

Did you find this content helpful? Yes No

100% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us