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