How assign colors particular columns in pivot table

[ramrongala]

Hi

Actually i added new values in dimension so that entire column i have to apply colors.

here 5 values(bold) are there these are the i added using  some logic.i want assign colors on those 5 columns like

Non land Total and non OS land total---one color(like light red)

non OS overall and OS overall---one color (like  red )

Total ---One color(like thick red)..

I tried so many ways like Dimensionality(),customformat cell, expression and dimension background but i am fail.

i want 2 types like below.. please help on this 2 types i attach QVW file.

[#2]

Not a real answer , but could you not move calculation of [Activity name] field to the script? You would save your self a lot of complexity when defining dimension, sorting, coloring, etc. Easier to maintain as well.

You could then just use simple expression (or calculated variable) in 'background' section.

[Anonymous]

Hi

Dimension background and expression background color is not working?

[senpradip007 · Accepted solution]

Have a look at the attachment.

[ramrongala]

Bro its working perfect..Thank you very much

[Anonymous]

HI Pradip,

Please share us the methods you used to achieve this. I am using Personal edition, so I cannot open the document.

Thanks in advance...