Expand my Community achievements bar.

SOLVED

How to export the pivot table reports ?

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
Level 3

Hi Ruthra_Devi_G,

 

This issue has been marked as a bug by Adobe Support Team.

 

Regards,

Anushka

View solution in original post

2 Replies

Avatar

Level 3

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

Avatar

Correct answer by
Level 3

Hi Ruthra_Devi_G,

 

This issue has been marked as a bug by Adobe Support Team.

 

Regards,

Anushka