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

    Show dimensions that aren't included in data

    Lucie Brett

      Hello

      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

      Lucie