Pivot View : Colouring column or row headers and Total row in 2.8

benjamin · June 4, 2014 6:56AM

Hi

Is it possible to colour in pivot view the column/row headers and the total row/column if total selected).I.e the first row or column (the headers) and the last row or column (the totals)

Thanks

Ben

paola · June 4, 2014 8:36AM

Total row/column can be coloured by selecting the last option from the Pivot view Colour menu.
There is no specific command to colour row/column headers, but you can achieve this by colouring the background, and then colouring the cells according to the measure values in rows (Pivot view colour menu) and tick the option to colour the totals.

Welcome!

Categories

Ideas Parade