Set background color ignoring the order in a pivot table

[#1]

Hi,

I'm trying to set the backcolor to 3 columns where the first values that represent the 20% are in a dark background and the 80% are in a light background.

In this image you can see my goal (done with excel). Columns are ordered by "% V" and all backgrounds are colored as I need.

This is what I get on the QV. Here the chart is ordered by "% Ud" and the colored backgrounds are correct in this column. However, the other 2 ("% V" and "% MC") are not the correct, because they're using the top values instead of the ranked values.

To do this I use one more hidden expression to achieve the number in %, the acumulated value (Acum. XX) and it's something like:

Ud + If(RowNo()=1,0,Above([Acum. Ud]))

This is only useful for the column that I use to order by.

The way I set colors to background is this:

If([% Acum. Ud]<0.2, 
          RGB(255,255,77), 
          If([% Acum. Ud]<0.8, 
                    RGB(255,255,195)
                    )
          )

I've tried diferent ways, using the function Rank() but I'm unable to achieve my goal.

The files attached are this two images, just for a better resolution.

Any help will be appreciated.

Thanks in adavanced.

[#2]

Hi,

Is your column calculated?

If it is, in your if statement, try to use the formula too.

i normally do it your way and it works.

[#3]

Hi nicksatch,

I don't have the problem with the background color expression but with coloring the other columns (the ones that are not in ascending order). When I set the color in my ordered column, everything works fine.