Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
PFA
i want to change background color in pivot table which i marked in single row
I have not seen Any Attachment, Would you attach the qvw file
or, You have to enter for all metrics of BG Color expression like below
If(ProductCode = '30-Day RFs', Green(), Red())
Hi anil,
can you check in above screen shot
i want to change expression back ground color also,it mean "30-Day RFs" back ground color i need to show in blue color.
Rgards
mahesh
Again Confused to me, Would you share sample to look the same?
Simple ,i want to change Expression back ground color
Ex:-
sum(sales)
100
200
300
here i want to change back ground color for sum(sales)
True that is how my first reply works. Or just use for Sum(Sales) color as Blue() like below. Expand the expression and then Give Blue() for BG Color in Definition. It should work
not like that,
i want to change Lable back ground color in expression tab
Like this?
Why dont you use Customer Format Cell using Ctrl+G and select a label right click Custom Format and change background color.
Exactly,but here when i drag the expressions its not working