To export a Widget to Excel, add the Export to Excel action from the Widgets Pane.  See The Export to Excel Button for details.

 

To export a Pivot Table to Excel, click on the properties button and navigate to Export To Excel.

Option	Description
All Cells	Exports all rows and values
Grouped	Uses one value to reference a Member when it appears multiple times consecutively
Merged	Merges adjacent cells that reference the same Member
Export	Begins the export process

 

For example, consider the following pivot:

 

All Cells Export:

Grouped Export:

Merged Export:

See Also