Background colour using expression

[ahmar811]

Hi All

I have pivot table with three dimension (Model, Month-Year, Product).I have a requirement to change the background colour using expression like

if(Model='PERSONAL CATEOGRY', OR  Model='COMMERCIAL CATEGORY' OR Model='NOT MAINTAINED' OR Model='Total',RGB(163,245,268))

It works fine,but when I arrange my dimension in horizontal direction the above expression doesn't work.

Please refer above screenshot.

Kindly suggest some solution

Thanks & Regards

Ahmar Ansari

[robert_mika]

maybe this will help

The second dimension... or how to use secondarydimensionality()

[ahmar811]

hi

Robert Mika

Thanks for your response but it not work....

[marcus_sommer]

I think there would be rather no way to access these header-column which is a kind of a help-column only to show the horizontal dimension. As a workaround you could use a second (dummy) expression maybe = '' and adjust the column-width to as small as possible (with a macro it could be nearly unvisible).

sub SetColumnWidth

set chart = ActiveDocument.GetSheetObject("CH17")

chart.SetPixWidth 3, 0

end sub

- Marcus

[dinuwanbr]

Hi,

Are you able to upload a sample?

Rgds,

Dinu1

[ahmar811 · Accepted solution]

Thank you all

I got my solution by using macro which is

sub HideColumn

    Call HideSubFunction("CH04",2)

end sub

private sub HideSubFunction(ch,n)

    set ch=ActiveDocument.GetSheetObject(ch)

    ch.SetPixWidh (n-1),0

end sub

Thanks & Regards

Ahmar Ansari