Copying Data From A Pivot Table Widget To Excel

[intapiuser]

Download: Pivot to Excel

This topic describes how to copy your Pivot table data to an Excel sheet, while preserving the same layout, formatting, and subtotals as the original widget in the dashboard. The procedure requires installing a plugin.

1. Download the attached zip file and extract the contents to C:\Program Files\Sisense\PrismWeb\plugins. If you are using version 7.2 and higher unzip the contents into your C:\Program Files\Sisense\app\plugins\ folder. Create the plugins folder if necessary.
2. From the widget's menu in the dashboard, click Copy Data to Clipboard.
   
3. Press CTRL+C to copy to clipboard.
   
4. Paste the copied to data in your Excel sheet.
   

Note: Only the visible data is copied. If you have paging, then increase the number of rows per page according to your needs.