Aggregation on measures in Union Query

Question

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...

asim cholas · Answer

CSV is meant to work like that. It will export the data in result set, not the view. for that you can use excel.