1

Discover Excel export – subtotal rows are merged

Hi Team,

 

When exporting Discover to Excel, the subtotal rows are exported as merged cells across multiple columns.

Is there a configuration or export setting in Discover to prevent subtotal rows from being merged in the Excel export?

 

 

Thanks,

Raveena

2 replies

null
    • Lead Consultant Advanced Analytics
    • Michael_Daun
    • 20 hrs ago
    • Reported - view

    Hi Raveena, 
    I do not know if you have the correct Pyramid version, but with one of the latest versions the export functionality was extended. I have V2025.10 and I get the following export options: 

     The effect of ticking or unticking "Merge Common Cells" is shown in the next two screenshots: 

     

    • Lead Consultant Advanced Analytics
    • Michael_Daun
    • 20 hrs ago
    • Reported - view

    I think, starting with V2025.02 the export options are availble.
    https://community.pyramidanalytics.com/t/60ypx08/pyramid-2025-02-released

Login to reply

Content aside

  • 1 Likes
  • 20 hrs agoLast active
  • 2Replies
  • 22Views
  • 3 Following