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 ?
Solved! Go to Solution.
To resolve this issue you would have to change the data source in your excel sheet.
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.
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
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:
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.