When using RowNo() null rows are shown

[#1]

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

[its_anandrjs]

Hi,

Your Script is correct = if(RowNo() = 1, 'Row 1 Here')

but for Rowno( ) = 1 only if you put = if(RowNo() = 2, 'Row 2 Here') it works for rowno 2 only

what is your requirement for rowno( ) in this type of chart let me know.

HTH

Regards,

Anand