Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table with Background expressions. I would like to prevent the color 'bleeding' into the Dimension columns below
I tried the right click 'Custom Format Cell' option but no luck. It simply is overidden by the expression!
Option 1
If(Technical='G',LightGreen(),If(Technical='R',LightRed(),If(Technical='Y',Yellow(255),White() )))
I changed the order of the white color fucntion but no change.
Option 2
If(Costs='Costs',White(),If(Costs='G',LightGreen(),If(Costs='R',LightRed(),If(Costs='Y',Yellow(255) ))))
The area highlighted in red is the area of concern.
Thank you all,
Brian
Hi,
can you give test applicatio.
Regards
Sure. I attached a QVW. Thanks!
Hi,
Please find the attachment of applicaton.
Regards
Very Nice. What was done to fix it? It looks like you swithced it to a Straight table?
Nice.he has checked each experssion value background and defined color condtion eg.
Technical='Technical'
Hi Shaik,
This is my thinking, apologies if it offend you.
I think it is good practise to write out the expression for all of us to learn from. Not everyone will be able to open the attachement.
Regards,
Gabriel
What he also did is was change it to Straight table and used Horizontal presentation.
This allowed more flexibility or prevented the labels from being colored over.
Now I look back the Pivot table was the wrong way to set this up in hindsight...
Final Output