Total two columns from different queries

[JohnnyCat]

Hello,

I have two different queries in my report.  Both are a count of employee, but they are from different tables.  How can I calculate the sum of all employees in list A and employees in list B, i.e. have a grand total of all employees from both lists?  Also, there is no relationship between these two tables.  Some employees are stored in table A, others are stored in table B.  I am using Cognos 8.

Thanks for your help.

[MFGF]

If the queries have the same number of items (with the same data types) you can union the queries together into a higher-level query, and perform your calculation there.

Regards,

MF.

[JohnnyCat]

Thanks,  that got me going.  The queries didnt have the same number of items, but I managed to work around it.

[mrcool]

Try 2 use tabular set....

[MFGF]

Hi MrCool,

Just to clarify, there's no longer any such thing as a Tabular Set in Cognos 8, which JohnnyCat is using here.  Tabular Sets have been replaced by Query Unions in Cognos 8.

Regards,

MF.

[mrcool]

Oh ok...thank u

[tosty]

Hi JhonnyCat,

can you tell me how you were able to solve this issue.

Thanks...