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.
Joseph Taylor
Posted 2 years ago·Last reply 1 year ago
8 comments
Joseph Taylor
OP1 year agoYep, this option is very handy - thanks!
DRay
·1 year agoHi joeshepper, dougnewton, HamzaJ,
Good news!
Yuliya Motiyets
·1 year agojoeshepper 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.
Joseph Taylor
OP2 years agoDRay 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.
DRay
·2 years agojoeshepper,
Would the feature described by dougnewton be a workable solution for you?
dougnewton
·2 years agoDRay 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.
Joseph Taylor
OP2 years agoThanks Hamza, that worked great!
Hamza Jap-Tjong
·2 years agoHey,
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