How to export the pivot table reports ?

Avatar

Avatar
Validate 1
Level 1
Ruthra_Devi_G
Level 1

Likes

2 likes

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
Ruthra_Devi_G
Level 1

Likes

2 likes

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
Ruthra_Devi_G
Level 1

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 (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 2
AnushkaRajan
Level 2

Likes

7 likes

Total Posts

25 posts

Correct reply

2 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
AnushkaRajan
Level 2

Likes

7 likes

Total Posts

25 posts

Correct reply

2 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
AnushkaRajan
Level 2

17-04-2020

Hi Ruthra_Devi_G,

 

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

 

Regards,

Anushka

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 2
AnushkaRajan
Level 2

Likes

7 likes

Total Posts

25 posts

Correct reply

2 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
AnushkaRajan
Level 2

Likes

7 likes

Total Posts

25 posts

Correct reply

2 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
AnushkaRajan
Level 2

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