2 Replies Latest reply on Mar 8, 2019 8:16 AM by anuj agrawal

    Hiding CrossTab column/ Replacing zeroes with blanks

    anuj agrawal

      Hello All,


      I am struggling with a problem that seems easy enough but I cant find a way. I have a dimension and 5 measures in a crosstab. What I want to achieve is that since "Measure 5" has all zeroes , instead of displaying zeroes(0.0), i can leave it blank so no number shows.


      The second step would be, that if "Measure 5" even has 1 non zero row, I display the zeroes so that the user knows that there is atleast one non-zero value in the column.



      Please help! And Thank You!!