I have a codelist as a dimension in a chart which should give me all possible entries of this codelist. But my chart only provides me with the entries of the codelist, which have values in it:
The dimension is dynamical: =if(list_nr=$listnr, listentext)
1- very good 60%
2 20%
3 20%
4 0%
5 0%
6 0%
The grades 4,5 and 6 are missing completly, although they exist in my codelist. But with the selections I have to made on my sheet in order to get the right data, this grades simply disappear because for this selection, theses grades do not exist. What can I do to have them displayed?
