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