3 Replies Latest reply on Sep 18, 2018 9:48 PM by mara.quindoza

    how to hide a row when using one measure value

    Mellisa mei

      Is there a way to hide the below blank row without hiding the rest of the rows?

       

      I have used one measure then created GSR % using the following formula zn((SUM([Gross Sales Revenue])))/LOOKUP(zn(SUM([Gross Sales Revenue])),-1) to get the difference between the two financial periods

      but stuck on how to hide the blank row on the 2017/2018