When using RowNo() null rows are shown

Wed, 21 Nov 2012 08:07:08 GMT

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

Re: When using RowNo() null rows are shown

its_anandrjs — Wed, 21 Nov 2012 08:19:23 GMT

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