How to include subtotals in download to Excel

I have a pivot table widget with subtotals enabled for 2 rows. The file generated using Download to Excel only includes the first row's subtotals. The subtotals for the secondary row enabled with subtotals are not included in the excel file.
All information I find about download to Excel states to use it to retain the formatting and display of the pivot but it isn't working for me. I expect the excel to have a subtotal row for each Department and also each person.
Department is the first row in my pivot, then Person. In the UI, the widget starts with Department, then person, where a subtotal per person appears, then a subtotal for each department.
How do I get the subtotals per person to also be included in download to Excel? The file includes subtotals for Department only.

BeckyCrittenden

Posted 2 years ago·Last reply 2 years ago

4 comments

jpacheco

·2 years ago

Hello BeckyCrittenden,

I wanted to follow up to see if the solution offered by HamzaJ worked for you.

If so, please click the 'Accept as Solution' button so other users with the same questions can find the answer faster. If not, please let us know so that we can continue to help.

Thank you.

BeckyCrittenden

OP2 years ago

Hi jpacheco

I've marked Accepted as Solution per your request, however details of the issue are not resolved as per my reply to HamzaJ just above this.

Thank you both for your help!