Colouring cells in pivot table

[#1]

I am colouring the background of a dimension in a pivot table with the following expression;

=if(Migrated<>'Yes',rgb(255,00,00),rgb(0,255,0))

basically for values of Yes i want the dimension green and for no i want them red.

This works ok but it colours the totals in red.

Can i stop the totals row from getting colour applied?

Could i change my expression, or is there another way?

[disqr_rm]

Try:

=if(Migrated = 'Yes',rgb(0,255,0), if(Migrated = 'No', rgb(255,0,0)))

[#3]

Tried that it didn't help, totals still get coloured red.

Is there some expression i could use to tell if it is a totals row?

Steve

[#4]

This is better,

=if(count(Migrated)>1,White(), if(Migrated = 'Yes', RGB(0,200,0), RGB(200,0,0)))

but still colours totals row if count=1.

There must be a better way of telling if we are on a totals row.

[#5]

I'm a little bit confused but why don't you use the propoerties dialogue of the pivot table to define your coloring? I have a pivot table where every row represents data of a formula. In the visualize dialogue of the pivot table's propoerties, you can define the coloring of each and every row. So if I don't want to color a specific table row's values, I simply don't define the coloring.

Isn't that working for you?

[#6]

I'm using qlikview 8.2. There is no visualize tab in the pivot table properties. There is a visual Cues, but that only shows expressions not dimensions.

[johnw]

I believe you want to check the dimensionality() value. From the help text:

"dimensionality ( )

Returns the number of dimension columns that have non-aggregation content. i.e. do not contain partial sums or collapsed aggregates.

A typical use is in attribute expressions, when you want to apply different cell formatting depending on aggregation level of data.

This function is only available in charts. For all chart types except pivot table it will return the number of dimensions in all rows except the total, which will be 0."