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