Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I change background color to a header in a Pivot Table, but only one column header?
It depends what you're using as a "column" in you table. In pivot it can be dimension, or expression, or dimension value.
If it is a dimesion, and you have only one dimension - it is possible, otherwise probably not.
If it is an expression, and you have only one expression - it is possible, otherwise probably not.
If it is a value of a dimension, it is possible.
In the first two scenarios, you have to use "custom format cell" for your dimension or expression. See "help" how to use it.
in the case of value of dimension, you can use background color for the dimension, conditional on the value (e.g. if(Year=2011, lightgreen())