3 Replies Latest reply: Sep 3, 2013 9:40 AM by Rajesh Vaswani RSS

    Color of total rows in pivot table - Null Row and Column

      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