This content has been marked as final. Show 3 replies
in a pivot table i want to change the background color for the total rows (for example total for every period). I did it like this in the background expression for the formula:
=if(rowno()=0 or isNull(rowno()), white(), ... )
But when I do it like this, the table adds a new column at the end which is totally empty and a new row at the bottom which is also totally empty. I think this is because of the rowno()=0.
Do you know a better way to do so?