1 Reply Latest reply on Jan 5, 2016 6:25 AM by Norbert Maijoor

    Show dimensions that aren't included in data

    Lucie Brett


      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.


      Does anyone have any ideas please?


      Thanks so much in advance