1 Reply Latest reply on Feb 7, 2019 7:47 AM by Nick Parsons

    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!!