Repeat Rows on Excel Exports for Tables and Pivots

Administrators use this system setting to specify whether cells that span rows and cells that span columns are repeated when exporting tables and pivot tables to Excel.

Valid Values

• On — If switched on, cells that span rows and cells that span columns are repeated, regardless of the Value Suppression setting in the Analysis editor.
• Off — If switched off, the Value Suppression setting in the Analysis editor is honored and cells that span rows and cells that span columns don't repeat when exporting tables and pivot tables to Excel. Default

Apply Required

No.

Change Effective

After a few minutes.

Edition

Enterprise only.

API Key and Values

API Key — AnalysisRepeatRowsExcelExportsTablesPivots

API Values —

• true
• false

Documentation Links

• When Do System Settings Take Effect?
• Typical Workflow for Using System Setting REST APIs
• Examples for System Setting REST APIs