i am using union query to get data from different tables. i have data like below in first and second reports.

First Report:

ABC   100

Second Report:

ABC   200

When i created report in pivot view its showing data how i am expecting like below.

ABC   300

But when i export output to CSV data is showing like below.

ABC   100

ABC   200

Anyone suggest me how can i get like Pivot view output in CSV?

Expected CSV like below

ABC   300

Thanks in advance...