cancel
Showing results for 
Search instead for 
Did you mean: 

excel export and totals

Former Member
0 Kudos

Hi, all-

When I export a report to Excel, it does not export the Totals boxes at the bottom of the report. Is there a way to do this?

For example, when I run a quarterly sales analysis report by item, then filter it to see a range of styles, I see the totals at the bottom of my screen in SAP, but the export in Excel does not pick up these fields.

Any way to do this?

Thanks,

Shelby

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Shelby,

This part of the report will not be exported I'm afraid. But with the AutoSum option in Excel it just takes a few seconds to recreate the totals.

Regards,

Nat

Answers (2)

Answers (2)

Former Member
0 Kudos

Thank you - the PDF does show totals.

Former Member
0 Kudos

Hi ,

I think it is calculated at run time and it will not be exported to excel . I guess you can try exporting to

PDF and see if this works .PDF is also related to PLD layout so I guess you will have some flexibilty.

Otherwise ,you need to use excel function to resolve your issue.

Hope this helps

bishal