If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Multiple query calculation

Started by tosty, 30 Aug 2006 06:36:38 AM

Previous topic - Next topic

tosty

Hellow every1,

This is my question.

I have a list that will have 11 rows the top 5 and the rest grouped as a single row.Ã,  For this I have a list with the top 5 and their total figure. And for the rest I need to substract the total for the entire list minus the total for the top 5.

For example:
Query 1 (entire rows)Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, 
Row1Ã,  Ã,  Ã, 20
Row2Ã,  Ã,  Ã, 22
Row3Ã,  Ã,  Ã, 23
Row4Ã,  Ã,  Ã, 30
Row5Ã,  Ã,  Ã, 31
Row6Ã,  Ã,  Ã, 32
Row7Ã,  Ã,  Ã, 33
TOTAL1 191

Query 2 (Top 5)
Row1Ã,  Ã,  Ã, 33
Row2Ã,  Ã,  Ã, 32
Row3Ã,  Ã,  Ã, 31
Row4Ã,  Ã,  Ã, 30
Row5Ã,  Ã,  Ã, 23
TOTAL2 149

TOTAL1-TOTAL2 = 42

But I wasnÃ,´t able to mix those calculations (total1 - total2) because I have them in different queries.

Is there any way to make calculations with items from different queries...?

IÃ,´m working with Serie 7 but I will have Series 8 in a few days so I can use solutions on any version.

ThankÃ,´s to all....