Aggregation on measures in Union Query

user12863665

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

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