Hi all,
I have a crosstab query which summarises number of retailers by region (rows), and by sales (columns). Sales can be 0-10, 11-20, and so on up to 60+.
I then have a report which displays the data in the crosstab query.
The problem is that if a small number of retailers is selected, then the crosstab may not have all the columns. E.g. there may be no retailers with 11-20 sales. In this case the report gives an error "Column [11-20] not found".
Is there any way to account for potential missing columns in this case ?
Thanks for your help,
Stepone.
I have a crosstab query which summarises number of retailers by region (rows), and by sales (columns). Sales can be 0-10, 11-20, and so on up to 60+.
I then have a report which displays the data in the crosstab query.
The problem is that if a small number of retailers is selected, then the crosstab may not have all the columns. E.g. there may be no retailers with 11-20 sales. In this case the report gives an error "Column [11-20] not found".
Is there any way to account for potential missing columns in this case ?
Thanks for your help,
Stepone.
