Visual Cue greater than total

[#1]

How can i add a visual cue, that includes the condition if greater than the total, highlight green?

the expression is variance calculation, right now its sell thru TY - sell thru LY.

[swuehl]

Try a background color attribute expression from expression tab (open attributes by clicking on the plus sign next to your expression) instead of a visual cue to enter a color expression like

=if( (sum(SalesTY)-sum(SalesLY) ) > (sum(total SalesTY)-sum(total SalesLY) ), green() )

I am not 100% sure about the sum expression, in principal you need to use something like

if( yourLineExpression > yourTotalExpresssion, green() )

where yourLineExpression is calculating your table line values per dimension (essentially your current expression), and yourTotalExpression calculates the total value.

See attached for a simple example.

Regards,

Stefan