Exporting Pivot Tables to Excel
You can export your pivot tables to Microsoft® Excel (XLSX). When you export a pivot table to Excel, the data that is exported is the data that is displayed in your widget.\ Exporting to Excel maintains your pivot's layout and structure, and values such as sub-totals, which are not maintained when you export a pivot table to CSV.\ The example below shows a pivot table exported to Excel versus CSV:
Note:
Up to 1.5 million cells can be exported.
Excel\
CSV\
To export a widget to Excel:
In Dashboard mode, click on the widget's menu, and select Download > ** Excel File**.
In Edit mode, click on the download icon, and select Download Excel File.
Limitations
Medecision Analytics supports the exporting of pivot tables of up to 1.5 million cells. Attempting to export a higher number of cells might result in a timeout. The following properties of a pivot table increase the probability of reaching a timeout when dealing with very large tables:
Sub totals or Grand totals
Complex formulas in Values
Data Security rules
Widget-level filters
To successfully export pivot tables, split large pivot table with many columns to separate smaller pivot tables.
The maximum number of rows per page is 200 rows.