Bad Dynamic Color display in Pivot Table

[#1]

Hi everybody, I'm facing trouble while displaying Pivot partial sum color, based on Dimension 1 value

Even if I put a formula through 'Custom format cell', it doesn't work properly.........what I expect is to

see the same color, based on DImension 1 value alla long the expressions displayed

Any idea?

qvw enclosed.

Thanks a lot,

Michaël

[Anonymous]

If I got the request right:
1. Remove custom format cells

2. Remove Row()=0 condition from all expressions

See  attached (I tried a few expressions and all dimensions on the bottom chart)

[#3]

Hi Michael, thanks a lot for your post. But this is not exactly the layout I try to implement. Target is that one:

Thanks. Michael.

[Anonymous · Accepted solution]

In this case, replace Row(0)=0 with Dimensionality()=1 in all your expressions. and the 2nd and 3rd dimensions

[#5]

Cool Michael! Many thanks!