Out-of-box Excel export has no summary lines existing in PDF export
We are using out-of-box export to PDF and export to Excel functionalities. In exporting to PDF, all group headings are expended with summary lines. However, there are no summary lines in Excel. Is there a way to also include summary lines in Excel that mimics the PDF export? Thanks!
***Updated by Moderator: Marissa. Removed user added #helpme and Ask the Expert group tags. Apologies for confusion, shouldn't have been an end-user option; updated categories***
Pegasystems Inc.
US
If I remember correctly, this is by design. The idea is that when a user exports to Excel, they likely intend to manipulate the data in the spreadsheet, so no summaries are exported.
Updated: 13 Oct 2016 13:55 EDT
Pegasystems Inc.
US
Ron, here's the SA that states this:
https://community.pega.com/support/support-articles/exporting-excel-does-not-include-sum-total-data