Total columns from different queries

[JohnnyCat99]

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.

 

[griffindm]

I would either write a SQL Union view to combine data from both sources (Impromptu) or use custom SQL in ReportNet to do the same thing.

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
Magic with Data
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[misscognos]

or in cognos 8, just union your queries together in report studio, total and boom.