Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey everyone,
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?
Regards
Hi.
Use Dimentionality()=0 or SecondaryDimentionality()=0 instead (depending on the field orientation).
Hi Michael.
In the Toolbar menu.select "grid design" then you right click on the total row and select "Custom cell format" and you choose the color you want.
Regards.
Hi Michael,
See if Visual Cues helps. More neater way of doing it.
thanks,
Rajesh Vaswani