In the attached packaged workbook, I have included an example of the data that I am working with. I have various statuses and I am showing number of records with each status and a measure for those records.
My boss has asked if it would be possible to show all status types which range from 101 to 120. I firstly explained that since no records in my data have status types 114, 115, 116 or 117 then we can't show them. In order to show them I would have to create fake records which would obviously affect numbers however I am asking the forum to see if there is a way of having set dimensions/columns and just populate those with the available data.