Hi I have a column of data that is either 1,2,3,4 and have changed the name of the column in a crosstab where 1 = Data Entry, 2 = Missing Data, ect by adding the following;
In the crosstab expert, selected the row field (that results in the numbers)->group options->options->customize group name->use a formula->x+2 and entered:
select {table.number} //your row field
case 1 : "Data Entry"
case 2 : "Missing Data"
case 3 : "Old Data"
case 4 : "Virtual Data"
I also created a chart and in the layout selected the crosstab and have the table.number selected for (subdivided by). The chart works fine except that I added a case 5 (case 5 : "All Other Data")to the crosstab formula above for table.number. The crosstab still works correctly (displays data for all cases, case 1 through case 5) but for some reason now the chart does not display any data for case 5 but still displays data for case 0 through case 4. I checked the data the report is using and there are all values 1-5 for table.number.
Any ideas, thanks.
In the crosstab expert, selected the row field (that results in the numbers)->group options->options->customize group name->use a formula->x+2 and entered:
select {table.number} //your row field
case 1 : "Data Entry"
case 2 : "Missing Data"
case 3 : "Old Data"
case 4 : "Virtual Data"
I also created a chart and in the layout selected the crosstab and have the table.number selected for (subdivided by). The chart works fine except that I added a case 5 (case 5 : "All Other Data")to the crosstab formula above for table.number. The crosstab still works correctly (displays data for all cases, case 1 through case 5) but for some reason now the chart does not display any data for case 5 but still displays data for case 0 through case 4. I checked the data the report is using and there are all values 1-5 for table.number.
Any ideas, thanks.