Forum Discussion

BeckyCrittenden's avatar
BeckyCrittenden
Cloud Apps
05-24-2024
Solved

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 sub...
  • jpacheco's avatar
    06-10-2024

    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's avatar
    BeckyCrittenden
    06-12-2024

    Hi HamzaJ

    I am not our Sisense Admin and do not have access our account's configuration. I am not able to check where you've requested. 
    Also on this topic - My colleague Rosemary filed a support case: https://community.sisense.com/t5/support-portal/bd-p/SupportPortal?page=casedetails&caseId=500Pk00000IUwYvIAL in early June. We received an update June 6 confirming Download to Excel as not including the secondary subtotals rows as a bug, advising it is under review with your R&D team and the fix is expected to come in your next major release. Please see below for that detail. I will mark this as solved, though it is not solved by the resolution suggestions offered here but from the support case linked above. 

    Hi Rosemary, I hope you are well. I would like to inform you that I was able to reproduce the issue on our end, and now we are working with our R&D team on the investigation that normally requires some time. It seems to be a known issue that was recently reported and slated to be fixed in our next major release L2024.2. The subtotal is missing in Excel export when there are either too many "Rows" or certain combination of fields is present. Disabling several "Rows" should result in an Excel file with subtotals included. I am setting this ticket to 'investigating' status and will be sure to let you know once additional information is available. Please feel free to update us if you would like to discuss it further. Best Regards, Oleh

    (from https://community.sisense.com/t5/support-portal/bd-p/SupportPortal?page=casedetails&caseId=500Pk00000IUwYvIAL)