COGNOiSe.com - The IBM Cognos Community

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....