COGNOiSe.com - The IBM Cognos Community

Hello

I have a list of zones :z1,z2,z3
a list of terminals t1,t2,t3
and turnovers

I have to create a kind of table like the one below:

	turnover year-1	turnover year	turnover evolution
Total z1 with t1+t2
Total z1 with t3+t4
Total z1+z2 with t1+t3
.....

actually I have a random combination of terminal and zones to filter  :'(

what should I use for that a table, cross table, list?
and there are 12x9 columns like that  :'( should I create 108 different queries?

thanks in advance for your help

Quote from: Avisto.sbu on 25 Apr 2014 11:17:47 AM
Hello

I have a list of zones :z1,z2,z3
a list of terminals t1,t2,t3
and turnovers

I have to create a kind of table like the one below:

Are you using a relational or dimensional model? Is there any specific pattern to the rules of what appears in rows, or are they all manually defined? MF. turnover year-1 turnover year turnover evolution Total z1 with t1+t2 Total z1 with t3+t4 Total z1+z2 with t1+t3 ..... actually I have a random combination of terminal and zones to filter  :'( what should I use for that a table, cross table, list? and there are 12x9 columns like that  :'( should I create 108 different queries? thanks in advance for your help

[/td][/tr][/table]