Issue with set analysis expression

[abc_18]

Hi,

I have a table chart in one of the dashboard, and data is as below:-

Product	Customer	Invoice	usage	level	Qty On Hand
xyz1	Daniel	abcd0847	Normal	1	1
xyz1	Daniel	abcd1454	Normal	1	1
xyz1	Daniel	-	-	-	0

Now I have to colour code the measure column(Qty On Hand), based on the condition and codition is as below:-

I need to sum Qty on Hand for product / Customer and if the total is greater than the Level column

then it is Blue.Here the level  column is on the per  invoice line so we would need to AVG the value.

for ex:- if sum(Qty on Hand )> Level, it means  (2>1) so it should be blue

Plesae suggest, how to write expression for this.

[Vegar]

Try this:

=if( sum( TOTAL <Customer> [Qty on Hand] ) > only(level), Blue(), Red())