2 Replies Latest reply on Sep 19, 2018 8:21 AM by maneesh.gaddam

    How to show table rows not represented in the data

    Sebastian Saint Arroman

      I have an application where my data is categoried into one of a number of categories, say C1, C2, C3, C4 and C5. However, my dataset may not contain all of these categories at a single time. I do not know which categories will be missing in advance.

       

      I want to create a table of the form:

       

      CategoryCost
      C1£100
      C2£200
      C3£130
      C4
      C5

      £40

       

      I.e. I want C4 to be displayed even if it does not exist in the underlying data at all.

       

      I have got around this by unioning the real data to a dummy table that lists every possible category with a £0 cost. However, if I then want to filter my data, for example, for categories with a cost over £50, the £0 cost data is also filtered out, giving me a table that looks like:

       

      CategoryCost
      C1£100
      C2£200
      C3£130

       

      While I want this to show:

       

      CategoryCost
      C1£100
      C2£200
      C3£130
      C4
      C5

       

      Is this possible?