How to export the pivot table reports ?

Ruthra_Devi_G

04-04-2016

I created the report using pivot table.Details are manipulating correctly in the table.But when i try to export the report as excel,It's not containing the table data.Is there any configuration has to be done ?

P1.png

p2.PNG

Accepted Solutions (0)

Answers (2)

Answers (2)

AnushkaRajan

04-02-2020

Hi Rudra_Devi_G,

 

To resolve this issue you would have to change the data source in your excel sheet.

 

Steps:

1. Select the pivot table on sheet 1. On selecting the table you will be able to see a tab "PivotTable Analyze" as highlighted in the image below.

AnushkaRajan_0-1580887946419.png

2. Click on the "PivotTable Analyze" tab -> "Change Data Source" option -> Select "Change Data Source" from the drop down as shown in the image below

AnushkaRajan_1-1580888181029.png

3. A "Change PivotTable Data Source" dialogue box would appear. Select "Pivot_1" sheet and then select the entire data range as shown in the image below:

AnushkaRajan_2-1580888402685.png

4. Click "OK". Now switch to "sheet" and you will be able to view the table data.

 

The reason we are facing this issue is because the table in sheet 1 is unable to locate its data source. By default, the data source is tagged as "Table1" in exportReport.js by Adobe Campaign.

 

Another work around would be modifying the exportReport.js which can be found in the Adobe folder (Path: Adobe\CampaignClassicv7\datakit\xtk\eng\js). However, as this is a system file, modification to this file should only be done post consulting the Adobe Support Team.

 

Regards,

Anushka