joeshepper's avatar
joeshepper
Cloud Apps
02-09-2024
Status:
Delivered

Give back the option to have merged rows in pivot table downloads

The Pivot table Excel download behaviour was recently changed. Previously, merged cells from the pivot table on the dashboard view would persist in a downloaded Excel file. Now, rows are not merged and are simply duplicated (as with the csv download).

While there are some upsides to this, this is a change our users and customers have reacted negatively to, asking us to revert the change, which of course we are unable to do.

We would like the option back for a download which maintains pivot table cell merging, replicating the way these appear in the dashboard. 

Dashboards & Analytics

10 Comments

  • HamzaJ's avatar
    HamzaJ
    Data Integration
    02-11-2024

    Hey,

    I think you can do this by disabling the excel v2 engine in the configuration manager. Atleast that is how it worked for us

    Unless you want to have both then I don't think that is possible

    Hamza

  • dougnewton's avatar
    dougnewton
    ETL
    02-15-2024

    DRay  maybe the "ask" here is that it's an option in the UI at download-time, or a setting in the dashboard or widget.  Rather than a server-side option that will affect all widgets on all dashboards.

     

  • YuliyaMotiyets's avatar
    YuliyaMotiyets
    Sisense Employee
    02-12-2025

    joeshepper I'm happy to share that the option for user to select how their data will be presented in the Excel file is now available with the Export to Excel v2 engine, since version L2024.3.

  • DRay's avatar
    DRay
    Admin
    02-13-2024
    Status changed:
    New Idea
    to
    Already in product
  • joeshepper's avatar
    joeshepper
    Cloud Apps
    02-15-2024

    DRay definitely. Giving the user control over whether to have cells merged / unmerged would be perfect, I've had users request both in the past, but the recent change to Excel export v2 caused some noise around that point particularly. I've switched it off for now on our instance as Hamzaj requested. Thanks.