1 Reply Latest reply: Nov 21, 2012 3:19 AM by Anand Chouhan RSS

    When using RowNo() null rows are shown

      Hi There,

       

      In my pivot chart I'd like to change the text of a cell if it is the first row in the section.

       

      = if(RowNo() = 1, 'Row 1 Here')

       

      This works however...

       

      If I use RowNo() in my pivot chart it no longer hides null rows that it normally would. i.e. Rows that would normally be hidden by the expression.

       

      Has anyone else had this problem?

       

      Please see attached....

       

      Thanks