Aggregation issue using different queries

[Raghuvir]

Hi All,

we have a requirement where we need the total of 3 columns ,column A,B and C. these 3 columns belong to 3 different queries for e.g. List 1, crosstab1 and list2.

we have made a new query named list3, where we need the total for column A(list1)+B(crosstab1) +C (list2)=Total(list3).

what we have done currently is unioned all the 3 queries but we are unable to achieve the total.

Please do guide us to find the solution.

Regards