Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I have a pivot report with nestled columns (see picture). I have been able to color total rows but not been able to format the nestled
columns (see attachment)
Mikael
Like this? The color setting is on the expression.
Hi Morgon.
Been able to set the coloring on row and measure. But problem to coloring the space between row and column (see picture). The problem is that I have nestled columns ?
Mikael (-;
Ah, Mikael, didn't notice that it was you asking first
If setting a background color on the presentation tab the column with labels is not filled.
With custom cell format it is possible to set a colour to the column (but only for all values)
If setting Cell Background Color Transparency on Style to 100% it would be possible to have another colored object behind the table, but is it work the extra trouble?
I don't find any good way neither, so it is interesting to see if anyone else knows.