Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello i need to know how to change the background color of specific column on a pivot table; can also been done dinamically?
Thanks
Marco
try to change the background color of expression lik
if(Sum(Sales)<0,Red(),Green())
Hi check this thread:
And how can be made statically on specific columns?
Marco
have a look at this
Hi,
it can be done int he visual Cues Tab
Hi,
Add this in the background color area of the expression, it will only format the required row
=if(<Enter the row name required>)
,rgb(255,255,0)
,rgb(255,255,255)
)
And if i have only dimensions on the pivot table is it possible to set the background?
Marco
how can you have oly dimesion in ur pivot table?