4 Replies Latest reply: Aug 31, 2018 5:15 AM by Bala Bhaskar RSS

    results differ with filter on dimension

    Jamie Lim

      I have a table that sums a measure and presents it against a dimension. I have allowed null dimension to display as well.

      e.g.

       

      DimensionMeasure
      A100
      B200
      C300
      -400

       

      figures are correctly presented against each dimension. However, when I apply a filter using any one for the value of the dimension (e.g. select dimension A under filter), the measure goes down to 0 (instead of showing 100) and my table shows null under dimension.

       

      DimensionMeasure
      -0

       

      Any idea what I would likely need to check here?

       

      Is it because I have some measures against null dimension?

       

      Regards,

      Jamie