add pivot table aggregation functionality back into the v2 Excel exporter

Thank you for your feedback! We are excited to share that we are now working on adding the option to export with merged (aggregated) rows to Export to Excel v2. To ensure the exporting flow best meet your needs, I would appreciate your input on which configuration option is most important:

1. Setting system-wide behavior by the administrator
2. Letting dashboard owner to define the desired format (merged or unmerged rows) per pivot widget/per dashboard
3. Letting the end-user to select the desired format for each exporting

Your feedback is invaluable to us as we strive to enhance your experience. Please let us know which option you find most beneficial.

Thank you!

Thanks YuliyaMotiyets .

Our preference would be your #3 option, but with a default that can be configured system wide. Meaning, as administrator, we could configure a setting where the default export behavior for a pivot table is either aggregated or not. But there's the option on a per-widget basis for the user to choose to download as something other than the default.

bminehart Please be aware that starting from version L2024.3 users can choose how they want their data displayed in the Excel file generated with v2 exporting engine.

Hello bminehart.

Thank you for your feedback. That feature was removed from v2 due to performance considerations, but, due to customer feedback like yours, our product team is investigating adding it back in. 

One of the ways we prioritize development efforts is by community interest. I encourage other users to vote and comment on this suggestion. The more engagement a request receives, the higher the likelihood of it being considered for implementation.

Thank you for being a valuable part of our community!

bminehart 

I want to make sure you see the response from Yuliya Motiyets. Are you able to provide feedback?

Hi DRay and YuliyaMotiyets - thanks for reaching out.

Could you rephrase your question? It sounds like the behavior being discussed in all three options is selecting the option to aggregate or not aggregate - is that correct?

And the question is: is it most important for this to be configurable system-wide, on a per-widget/dashboard basis, or on a per-export basis, is that right?

-Ben

You got it right bminehart 

1. Our users want the Excel exports from pivot tables to freeze the rows and columns as is done on the dashboard. This feature was in our Windows Sisense (8.2.4) but removed from the Linux Sisense (L 2025.1, V2 export engine) we are migrating to.

2. They also want heavier lines to appear between the first Rows variable values to make large Excel exports easier to navigate.

3. Letting the dashboard owner define the merged or unmerged rows would be better for most of our users  as they prefer merged and find extra clicking egregious.