Unions and Grouping with Totals

[KKSaland]

I have queries A, B and C.  A and B equal Union 1.  Union 1 and C equal Union 2.  I am using Union 2 for my list report.  My problem is when I group by Area and Department I only get a total by Area and nothing by Department.  I need both.  Any assistance would be appreciated.

.k

[hittony]

I think you should give more details for that someone could help you ;)

Do you have something in your list column Department before grouping ?

[Lynn]

Why do you union A and B and then union the result with C? Why not just create one union with A, B, and C?

[BigChris]

Can you do that? I genuinely thought you could only union two queries at a time. If you can union three (or more) that would be excellent. Is that something that's only in later versions / updates?

[MFGF]

Can you do that? I genuinely thought you could only union two queries at a time. If you can union three (or more) that would be excellent. Is that something that's only in later versions / updates?

Yep! Once you have the obvious two queries feeding into your union, simply drag another query and drop it onto the Union object. It's been there as long as I can remember - I'm pretty sure it was there in Cognos 8... It's just not obvious unless someone tells you or you stumble on it by accident :)



MF.

[BigChris]

(Expletive deleted) brilliant!! That's just made my morning. Thanks all.